Welcome to WebmasterWorld Guest from 54.147.28.255

Forum Moderators: open

Message Too Old, No Replies

Display results from 2 tables filtering same results

     
3:25 pm on May 3, 2011 (gmt 0)

New User

5+ Year Member

joined:May 3, 2011
posts: 3
votes: 0


Hi,

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)

and

SELECT test1.email FROM test1 LEFT JOIN test2 ON test2.email = test2.email WHERE (test1.email != test2.email)

Neither Worked

Hopefully somebody can help me out.

Thanks
3:31 pm on May 3, 2011 (gmt 0)

Preferred Member

10+ Year Member

joined:July 28, 2000
posts: 580
votes: 0


select email from table1 where email not in (select email from table2)
3:37 pm on May 3, 2011 (gmt 0)

New User

5+ Year Member

joined:May 3, 2011
posts: 3
votes: 0


that was tooo easy!

Thanks for your help

Final Query:
SELECT email FROM test1 WHERE email NOT IN (SELECT EMAIL FROM test2)
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members