help with select where not in another table

Posted on 2012-08-13
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

how do I do this?  Thank you
Question by:arthurh88
    LVL 12

    Accepted Solution

    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

    LVL 3

    Expert Comment

    Please try below:
    SELECT p.* FROM poolclients p inner join providers v on

    Open in new window


    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now