lundi 4 juillet 2016

Select results from 2 tables if no matches found in the third one


I have three tables

t1
--------------
userID
userEmail
userName
userType

t2
--------------
businessID
businessUserID

t3
--------------
recordID
recordBusinessID

I need to retrieve records if no results are found in t3

SELECT
   t2.businessID,
   t1.userEmail,
   t1.userName
FROM t2
LEFT JOIN t1 ON (t1.userID = t2.businessUserID)
LEFT JOIN t3 ON (t3.recordBusinessID = t2.businessUserID)
WHERE userType = 'active'
AND t3.recordID IS NULL

It seems like I should be getting results, because my current t3 is empty, but I don't. What am I missing?


Aucun commentaire:

Enregistrer un commentaire