• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 508
  • Last Modified:

help with select where not in another table

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
0
arthurh88
Asked:
arthurh88
1 Solution
 
Habib PourfardCommented:
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

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

Open in new window

0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now