现在有表:
table1
table2
我们取出table2中没有c,d
select name
(
SELECT name,count(name) as count1 from
( select name from table1
union ALL
select name from table2
)aa GROUP BY name
)bb where count1=1
结果:
现在有表:
table1
table2
我们取出table2中没有c,d
select name
(
SELECT name,count(name) as count1 from
( select name from table1
union ALL
select name from table2
)aa GROUP BY name
)bb where count1=1
结果: