| Welcome to WebmasterWorld Guest from 220.127.116.11 |
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
|Subscribe to WebmasterWorld|
|Display results from 2 tables filtering same results|
| 3:25 pm on May 3, 2011 (gmt 0)|
This is probably very easy but I seem to be struggling on this so hopefully some body can help.
I am trying to display results from field 'email' in table1, When I display the results I don't want table1.email to appear if it exists in table2.email.
So far I have tried these 2 statements:
SELECT test1.email FROM test1, test2 WHERE (test1.email != test2.email)
SELECT test1.email FROM test1 LEFT JOIN test2 ON test2.email = test2.email WHERE (test1.email != test2.email)
Hopefully somebody can help me out.
| 3:31 pm on May 3, 2011 (gmt 0)|
select email from table1 where email not in (select email from table2)
| 3:37 pm on May 3, 2011 (gmt 0)|
that was tooo easy!
Thanks for your help
SELECT email FROM test1 WHERE email NOT IN (SELECT EMAIL FROM test2)
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
© Webmaster World 1996-2014 all rights reserved