22,209
社区成员
发帖
与我相关
我的任务
分享
select id,name,type from A where [TYPE]='会员'
union all
select id,name,type from B where [TYPE]='会员'
union all
select id,name,type from C where [TYPE]='会员'
SELECT * FROM (
select id,name,type from A union all
select id,name,type from B union all
select id,name,type from C
)T where [TYPE]='会员'