================================================================================================【A】
SELECT customer_id
from hyperlipemia_supervisorWHERE customer_id LIKE '%%'
GROUP BY customer_id
================================================================================================【B】
SELECT customer_id
from hypertension_supervisor
WHERE customer_id LIKE '%%'
GROUP BY customer_id
================================================================================================【C】
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