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