MySQL在2表中只找到不同的

Question

I have 2 table in mysql. table1 and table2.

In table1 is number, email and phone number. In table 2 same, but sometime different email or phone number. i want to list of records where number is same and email or phone number different. sometime both email and phone number is different. tnx.

Answer 1

You can join your tables, then filter accordingly:

SELECT *
FROM   table1 JOIN table2 USING (number)
WHERE  table1.email <> table2.email
    OR table1.phonenumber <> table2.phonenumber