有表:get_sms 其中themobile字段 存的是手机号码SELECT thedate,thetime,themobile FROM get_sms有另外一个表:member 其中user_mob 也是存的手机号码 user_xm 这个是手机用户姓名
select user_mob,user_xm from member求:用一个SQL语句:查出get_sms的信息但要调出member的用户姓名: thedate,thetime,themobile,user_xm上面这个问题让大家见笑了,下面还有一个这样的问题就是在member 中有三个手机号 如下:select user_mob1 usermob2,user_mob3,user_xm from member而get_sms 中的手机号可能是对应user_mob1,也可能是user_mob2 也可能是user_mob3只要三个号中有一个号能与get_sms 中的手机号相同,就调用这个姓名,所以同样要查出:thedate,thetime,themobile,user_xm
select user_mob,user_xm from member求:用一个SQL语句:查出get_sms的信息但要调出member的用户姓名: thedate,thetime,themobile,user_xm上面这个问题让大家见笑了,下面还有一个这样的问题就是在member 中有三个手机号 如下:select user_mob1 usermob2,user_mob3,user_xm from member而get_sms 中的手机号可能是对应user_mob1,也可能是user_mob2 也可能是user_mob3只要三个号中有一个号能与get_sms 中的手机号相同,就调用这个姓名,所以同样要查出:thedate,thetime,themobile,user_xm
select thedate,thetime,themobile,user_xm from get_sms a join member b on a.themobile=b.user_mob
第二个问题:
select thedate,thetime,themobile,user_xm from get_sms a join member b on a.themobile=b.user_mob1 or a.themobile=b.user_mob2 or a.themobile=b.user_mob3
if ( object_id('t') IS NOT NULL )
drop table tcreate table t(id char(10),name char(10))insert t
select 'i1','tom' union all
select 'o2','tim' union all
select 'c3','mary'select * from t where CHARINDEX('i',id)>0 or CHARINDEX('i',name)>0
厉害!
select thedate,thetime,themobile,user_xm from get_sms a join member b on a.themobile=b.user_mob
select thedate,thetime,themobile,user_xm
from get_sms a left join member b
on a.themobile=b.user_mob 2.
select thedate,thetime,themobile,user_xm
from get_sms a left join member b
on a.themobile=b.user_mob1 or a.themobile=b.usermob2 or a.themobile=b.user_mob3
select thedate,thetime,themobile,user_xm from get_sms a join stu_info.member b on a.themobile=b.user_mobselect thedate,thetime,themobile,user_xm from get_sms a join stu_info.member b on a.themobile=b.user_mob1 or a.themobile=b.user_mob2 or a.themobile=b.user_mob3這樣?
select thedate,thetime,themobile,user_xm from get_sms a ,stu_info.member b
where a.themobile=b.user_mobselect thedate,thetime,themobile,user_xm from get_sms a ,stu_info.member b
where a.themobile=b.user_mob1 or a.themobile=b.user_mob2 or a.themobile=b.user_mob3