Results 1 to 7 of 7
Thread: Problem with JOIN query
Dec 1, 2012, 11:52 #1
Problem with JOIN query
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:
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.