getting around sub-selects in mySQL

A

admin

Administrator
Staff member
i have three tables: members, teamMembers, and teamLeaders. Each table has a field called "memberID". what i want to do is get all the memberIDs from the members table that are not in the teamMembers and teamLeaders table. the only way i know is using sub-selects which mySQL does not allow. does anyone know how to make a query for this that is compliant with mySQL?

thanks in advance.
 
You must log in or register to reply here.
Back
Top