看了“a5987655”同学的评论,感觉我理解的又多了点,蟹蟹你,但是我生成表的做法不同,就借花献佛说一下我的答案: create table t4 as select t1.A,t1.B,t2.E,t2.F,t3.J,t3.K from t1 left join t2 on t1.A=t2.A left join t3 on t2.E=t3.E;
第2个回答 2016-07-29
select A.a,A.b,B.e,B.f,C.j,C.k into TableD from TableA a left join TableB b on a.a=b.a left join TableC c on b.e=c.e本回答被提问者和网友采纳