Select tbla.*,tblb.* From tbla
Inner Join tblb on tbla.recevie_id = userid Or tbla.send_id = userid
Where tblb.regdate > 1111111
Inner Join tblb on tbla.recevie_id = userid Or tbla.send_id = userid
Where tblb.regdate > 1111111
select u* ,ut.* from tblA as u
left outer join tblB as ut
where ut. regdate > 1111111
应该加个on (u.recevie_id=ut.userid or u.send_id=ut.userid)对吧,不然数据查出来会不正确的
from tblA ,tblB
where tblA.recevie_id=tblB.userid or tblA.send_id =tblB.userid where tblB.regdate> 1111111
from tblA ,tblB
where tblA.recevie_id=tblB.userid or tblA.send_id =tblB.userid where tblB.regdate> 1111111
from tblA ,tblB
where (tblA.recevie_id=tblB.userid or tblA.send_id =tblB.userid )and tblB.regdate> 1111111
SELECT * from tblA join tblB on tblB.regdate > 1111111 and (tblA.recevie_id = tblB.userid or tblA.send_id = tblB.userid);