select m.MasterPUID , n.Name Name_Master, m.ClientPUID , t.Name Name_Client from tb2 m left join tb1 n on m.MasterPUID = n.PUID left join tb2 n on m.ClientPUID = t.PUID
select a.*,b.Name as MasterName,c.Name from table2 as a inner join table1 as b on a.MasterPUID=b.PUID inner join table1 on a.ClientPUID=c.PUID
select a.masterPUID,b.name,a.ClientPUID,a.name from 表1 b,表2 a where a.MasterPUID=b.PUID
select a.MasterPUID,b.name,a.ClientPUID,c.name from 表2 a join 表1 b on a.MasterPUID=b.PUID join 表1 c on a.ClientPUID=c.PUID
from tb2 m
left join tb1 n on m.MasterPUID = n.PUID
left join tb2 n on m.ClientPUID = t.PUID
from table2 as a inner join table1 as b on a.MasterPUID=b.PUID inner join table1 on a.ClientPUID=c.PUID
from 表1 b,表2 a
where a.MasterPUID=b.PUID
a.MasterPUID,b.name,a.ClientPUID,c.name
from
表2 a join 表1 b
on
a.MasterPUID=b.PUID
join
表1 c
on
a.ClientPUID=c.PUID