34,590
社区成员
发帖
与我相关
我的任务
分享
union all --包含重复
union--去除重复
select AID AS [ID],Name from 表A
union all
select BID AS [ID],Name from 表B
--用union all
select AID,Name from 表A
union all
select BID,Name from 表B
--用union all
select AID,Name from 表A
union all
select BID,Name from 表B
SELECT AID,NAME FROM tb1
UNION ALL
SELECT ID,NAME FROM tb2