mysql_合并两个表中相同字段

================================================================================================【A】

SELECT customer_id 

from hyperlipemia_supervisor 
WHERE customer_id LIKE '%%'
GROUP BY customer_id

================================================================================================【B】

SELECT customer_id 
from hypertension_supervisor 
WHERE customer_id LIKE '%%'
GROUP BY customer_id

================================================================================================【C】

SELECT a.customer_id FROM hyperlipemia_supervisor a 
WHERE a.customer_id LIKE '%%'
UNION 
SELECT b.customer_id FROM hypertension_supervisor b
WHERE b.customer_id LIKE '%%'

A、B 结果加起来是 C

如： A查出 1001,1002,1005    B查出 1001,1003,1004

则： C查出 1001,1002,1003,1004,1005