34,576
社区成员
发帖
与我相关
我的任务
分享
insert into E(1,2,3,4,5,6)
select distinct a.2,a.3,c.8,d.9,d.10 FROM A a left join B b on a.2=b.5
left join C c on B.5 = c.8 left join D d on c.8=d.10
insert into E(1,2,3,4,5,6)
select k.*,c.8,d.9,d.10
FROM (select distinct 2,3 from A ) k left join B b on k.2=b.5
left join C c on B.5 = c.8 left join D d on c.8=d.10
insert into E(1,2,3,4,5,6)
select a.2,a.3,c.8,d.9,d.10
FROM (select distinct 2,3 from A ) k left join B b on k.2=b.5
left join C c on B.5 = c.8 left join D d on c.8=d.10