高难度SQL多表联合查询求解

来源：百度知道 编辑：UC知道 时间：2024/06/22 07:12:41
比如说我现在有4张表ABCD
A aid apwd aname asex typeid
B bid bpwd bname bsex typeid
C cid cpwd cname csex typeid
D did dpwd dname dsex typeid
现在我再建个新表E ,表里有三个字段：newid newpwd typeid
现在要把上面4张表里的id pwd 全部塞进新表E里，typeid作用是标示
该账号是哪张表的，我分别取的是1，2，3，4，请大虾门指点下
这个SQL语句怎么写

create view all as select aid,apwd,typeid from A union select bid,bpwd,typeid from B union select cid,cpwd,typeid from C union select did,dpwd,typeid from D
insert into newtable select * from all

insert into newtable select aid,apwd,typeid from A union all select bid,bpwd,typeid from B union allselect cid,cpwd,typeid from C union all select did,dpwd,typeid from D
上面哪个朋友你少了一个all
没有all的话你把重复的过滤拉,就不符合要求了