We help IT Professionals succeed at work.

help with select where not in another table

Medium Priority
531 Views
Last Modified: 2012-08-13
Table providers has a column email
Table poolclients has column email1

I want to select all records from poolclients where email1 is found in providers.email

how do I do this?  Thank you
Comment
Watch Question

Software Developer
CERTIFIED EXPERT
Top Expert 2012
Commented:
select all records from poolclients where email1 is found in providers:
SELECT email1 FROM poolclients WHERE email1 IN (SELECT email FROM providers)

Open in new window

Top Expert 2012

Commented:
Please try below:
SELECT p.* FROM poolclients p inner join providers v on p.email1=v.email

Open in new window

Explore More ContentExplore courses, solutions, and other research materials related to this topic.