union:对两个结果集进行并集操作,不包括重复行,同时进行默认规则的排序;
union All:对两个结果集进行并集操作,包括重复行,不进行排序;
SELECT count(0)
FROM (SELECT DISTINCT ttt.id
FROM (SELECT t.id, t.supplier_id
FROM (((SELECT tm.id, tmsra.supplier_id FROM 。。。 ))
UNION all (SELECT tm.id, tmsra.supplier_id from 。。。
)) t GROUP BY t.id, t.supplier_id HAVING count(*) = (1 + 1)) ttt) table_count;
理解:合并结果集取交集