Hello guys!
I need your help.

I have tow table in MYSQL:
  1. tbl_login 5.739 rows, alias A;
  2. 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:
Code:
SELECT
	A.email,
	B.email
FROM
	tbl_mailing_list A
JOIN tbl_login B ON A.email = B.email

2690 rows in set
but these are the lines that have emails matching between the two tables...

Thank you for the suggestion.