MINUS
--取A表中有且B表中无的
SELECT * FROM table_a MINUS SELECT * FROM table_b;
UNION
--取A表中有或B表中有的
SELECT * FROM table_a UNION SELECT * FROM table_b;
MINUS
--取A表中有且B表中无的
SELECT * FROM table_a MINUS SELECT * FROM table_b;
UNION
--取A表中有或B表中有的
SELECT * FROM table_a UNION SELECT * FROM table_b;