I need your help.
I have tow table in MYSQL:
- tbl_login 5.739 rows, alias A;
- tbl_mailing_list 3.736 rows, alias B
The field to be related tbl_login (A) and tbl_mailing_list (B) is e`email`.
I need to know any emails of the table B are not present in table A and try this query:
but these are the lines that have emails matching between the two tables...Code:SELECT A.email, B.email FROM tbl_mailing_list A JOIN tbl_login B ON A.email = B.email 2690 rows in set
Thank you for the suggestion.