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

, 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 Committee to Regulate and Control Marijuana http

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

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.regulatemarijuana.org -- MySQL General Mailing List For list archives: http