mysql ½»¼¯ ²î¼¯ ²¢¼¯

½»¼¯ SELECT a.*, b.* FROM a JOIN b ON a.id = b.id; ²î¼¯ SELECT * FROM table_a ta EXCEPT SELECT * FROM table_b tb ; SELECT ta.* FROM table_a ta WHERE ta.a