表a
uid(int) tid(int) tname(nvarchar16) tpass(varchar22)
表b
xid(int) tid(int) bname(varchar16) bpass(varchar22)
我如何把两个表的数据变成一个表c
表c
id(int) tid(int) name(nvarchar16) pass(varchar22)
uid(int) tid(int) tname(nvarchar16) tpass(varchar22)
表b
xid(int) tid(int) bname(varchar16) bpass(varchar22)
我如何把两个表的数据变成一个表c
表c
id(int) tid(int) name(nvarchar16) pass(varchar22)
union all
select xid,tid,bname,bpass from b
select uid id , tid , tname name , tpass pass from a
union all
select xid id , tid , bname name , bpass pass from b
select * into tbC from(
select * from tbA union all
select * from tbB) a
insert into c
(select uid id,tid,tname name,tpass pass from a
union all
select xid id,tid,bname name,bpass pass from b)