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 is NULL;
---
Rodney Broom
Programmer: Desert.Net
Spam filter: sql database
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
