From: MYSQL <[EMAIL PROTECTED]>
> I need to run a querry to return the following: date, email, client from
> table2 where the email address in table2 isn't already in table1.
Try this:
SELECT *
FROM table2
LEFT JOIN table1 ON table1.email = table2.email
WHERE table1.email
I have 2 tables in my mysql database.
table1 is a master list with just one field -- email.
table2 is smaller, and contains three fields -- date, email, client
I need to run a querry to return the following: date, email, client from
table2 where the email address in table2 isn't already in tab
