比较身高与伴侣细节 [英] compare height with partner details

问题描述

i有一个register_master表，其中有一个用户的Height字段

和partner_master表有一个HeightFrom和HeightTo字段



register_master

----------------

reg_id

身高



partner_master

-------- ------

partner_id

reg_id

heightfrom

heightto



值插入这些字段为（4英尺，4英尺1英寸，5英尺2英寸，7英尺4英寸）



i想要sql查询匹配合作伙伴身高



注册主人; s id从partnermaster的身高到身高查找身高



怎么写查询

解决方案

试试这个

还要明白这只是一个示例查询..如果有任何问题，你可以告诉我。你也可以在这里开发..

 选择 Partner_ID 来自 Partner_Master pm  INNER  > JOIN  Register_Master rm  on  pm.Reg_ID = rm.Reg_Id 
 其中 rm.Height   pm.HeightFrom 和 pm.HeightTo 

hi,

i have a "register_master" table which have a user's "Height" field
and "partner_master" table have a "HeightFrom" and "HeightTo" fields

register_master
----------------
reg_id
height

partner_master
--------------
partner_id
reg_id
heightfrom
heightto

values inserted in these fields as (4 feet, 4feet 1inch, 5feet 2inch ,7feet 4inch)

i want sql query for matching partner with height

register master;s id find height from partnermaster's heightfrom to heightto

how to write query

解决方案

Try this
Also understand that this is just a sample query..You can let me know if there is any issue..and also you can develop from this here on..

Select Partner_ID from Partner_Master pm INNER JOIN Register_Master rm on pm.Reg_ID=rm.Reg_Id
Where rm.Height between pm.HeightFrom and pm.HeightTo

这篇关于比较身高与伴侣细节的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！