select records not in a *particular* many-to-many relationship

but they would be for other groups, not "Group1." One more thing: this is easily done with subqueries, but for performance reasons, I need to do it with explicit joins. Anyone know how I can do this? Thanks, marco -- Marco Carbone Webmaster/Web Developer Com

Re: select records not in a *particular* many-to-many relationship

D = ug.userID and ug.groupID = 'Group1' WHERE ug.groupID IS NULL But I have three tables, not two. In other words, I have the name 'Group1,' but not the id. -- Marco Carbone Webmaster/Web Developer Committee to Regulate and Control Marijuana http://www.regulatemari