17,377
社区成员
发帖
与我相关
我的任务
分享
SELECT t1.a1,c.aname,t1.b1,c.bname,t1.a2,d.aname,t1.b2,d.bname
from yewu t1
left join mast c on (t1.a1=c.a and t1.a2=c.b)
left join mast d on (t1.a2=d.a and t1.a2=d.b)
where t1.a1=c.a and t1.b1=c.b
SELECT t1.a1,c.aname,t1.b1,c.bname,t1.a2,d.aname,t1.b2,d.bname
from yewu t1
left join mast c on (t1.a1=c.a and t1.a2=c.b)
left join mast d on (t1.a2=d.a and t1.a2=d.b)
where t1.a1=c.a and t1.b1=c.b
SELECT t1.a1,c.aname,t1.b1,c.bname from yewu t1 ,mast c where t1.a1=c.a and t1.b1=c.b
union
SELECT t1.a2,c.aname,t1.b2,c.bname from yewu t1 ,mast c where t1.a2=c.a and t1.b2=c.b