110,535
社区成员
发帖
与我相关
我的任务
分享
select * ,'A' as Source from A where name like '%a%'
union all
select * ,'B' as Source from B where name like '%a%'
union all
select * ,'C' as Source from C where name like '%a%'
union all
select * 'D' as Source from D where name like '%a%'