Hello,

I have a situation with SQL query. I have the following 2 tables.

Table 1
Name Email
aa [email protected]
bb [email protected]
cc [email protected]
dd [email protected]
ee [email protected]
bb [email protected]

Table 2
Name Email
bb [email protected]
dd [email protected]

Now I wish to eliminate the common emails of Table 2 from Table 1 and send email to the rest of the person. This means emails are going to aa, bb (last person), cc and ee. I am trying to use DISTINCT keyword with email and getting success. But along with the email I want to get the names of the corresponding persons. I wish to get distinct emails and their corresponding names and send a common emails to each of them. I need to know the sql query to overcome the situation.

Please help. Thank you so much.