22,209
社区成员
发帖
与我相关
我的任务
分享
select isnull(isnull(isnull(a.id,b.id),c.id,d.id),a.name,b.sex,c.year,d.tel from 表1 a
full join 表2 b on a.id=b.id
full join 表3 c on a.id=c.id
full join 表4 d on a.id=d.id
select a.id,a.name,b.sex,c.year,d.tel from 表1 a
left join 表2 b on a.id=b.id
left join 表3 c on a.id=c.id
left join 表4 d on a.id=d.id