麻烦帮我优化下这个SQL,谢谢

[Thaiki]

SELECT * from tblA WHERE
recevie_id IN
(select userid from tblB where regdate>1111111)
OR send_id IN
(select userid from tblB where regdate>1111111)

也就是条件结果相同,但要查两次,有没有办法改?

[fangq]

Select tbla.*,tblb.* From tbla
Inner Join tblb on tbla.recevie_id = userid Or tbla.send_id = userid
Where tblb.regdate > 1111111

[Thaiki]

1楼的不对撒...

[tantaiyizu]

select u* ,ut.* from tblA as u 
left outer join tblB as ut 
where ut. regdate > 1111111

[gs6fox]

四楼的忘了把连接条件加进去了
应该加个on (u.recevie_id=ut.userid or u.send_id=ut.userid)对吧,不然数据查出来会不正确的

[gs6fox]

晕,是三楼

[Thaiki]

哈哈...
不过都不是我要的结果哦

[怡天网]

select table.*
from tblA ,tblB
where tblA.recevie_id=tblB.userid or tblA.send_id =tblB.userid where tblB.regdate> 1111111

[怡天网]

?????????????
给分快快快

[怡天网]

select *
from tblA ,tblB
where tblA.recevie_id=tblB.userid or tblA.send_id =tblB.userid where tblB.regdate> 1111111

[怡天网]

select *
from tblA ,tblB
where (tblA.recevie_id=tblB.userid or tblA.send_id =tblB.userid )and tblB.regdate> 1111111

[Thaiki]

baihaks不对啊!

tblB的userid不是唯一的!

[SysTem128]

SELECT * from tblA join tblB on tblB.regdate > 1111111 and (tblA.recevie_id = tblB.userid or tblA.send_id = tblB.userid);