Free for PREMIUM members
SELECT email1 FROM poolclients WHERE email1 IN (SELECT email FROM providers)
Open in new window
SELECT p.* FROM poolclients p inner join providers v on p.email1=v.email
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.