求 SQL多表查询，能查出重复值的语句

Question

 

Answer 1

SELECT A,count(A) as count FROM
(SELECT A as A FROM table1
UNION ALL
SELECT B as A FROM table2
UNION ALL
SELECT C as A FROM table3)
GROUP BY username HAVING count(A) >1;