[w3schools.com...]

Or, if you need distinct values for each query separately (it's not clear what you are after), use the DISTINCT keyword.

[edited by: FalseDawn at 7:41 pm (utc) on Aug. 14, 2006]

Actually I need to take all b.id from the first statment that are not contained into the secnd table ad MemberID.

Thank you, Ani

Actually I need to take all b.id from the first statement that are not contained into the second table as MemberID.

Sorry for the spelling mistakes...

Thank you, Ani

Anyone pls help me :(((

SELECT b.id FROM transactions a JOIN members b ON a.UserID=b.UserID AND a.SiteID=b.SiteID WHERE b.id NOT IN (SELECT MemberID FROM questionnaire)

Or if your SQL does not support subqueries, reformulate as a LEFT JOIN

SELECT b.id FROM transactions a JOIN members b ON a.UserID=b.UserID AND a.SiteID=b.SiteID LEFT JOIN questionnaire q ON b.id=q.MemberID WHERE q.MemberID IS NULL

Hello,
Upon running:
SELECT b.id FROM transactions a JOIN members b ON a.UserID=b.UserID AND a.SiteID=b.SiteID LEFT JOIN questionnaire q ON b.id=q.MemberID WHERE q.MemberID IS NULL

I get :

#1064 - You have an error in your SQL syntax near 'ON a.UserID=b.UserID AND a.SiteID=b.SiteID LEFT JOIN questionnaire q ON b.id=q.M' at line 1

Can you advise, thank you :(

it's probably a bracketing issue, try:

SELECT b.id FROM ((transactions a JOIN members b ON a.UserID=b.UserID AND a.SiteID=b.SiteID) LEFT JOIN questionnaire q ON b.id=q.MemberID) WHERE q.MemberID IS NULL