select a.*,b,* from A a,B,b where a.uid=b.uid and b.uid=4;
select A.* from A left join B on A.uid = B.uid where A.uid = 4
select a.*,b.* from a,b where a.uid=b.uid and b.uid = 4
