[snip] I'm pretty sure this is a good starting point, but that's just matching resource to resource without excluding Lincoln from building an Ark (no canvas).
mysql> SELECT project.proj,project.rsrc,people.name FROM project LEFT JOIN people ON project.rsrc=people.rsrc; +----------+-------------+---------+ | proj | rsrc | name | +----------+-------------+---------+ | ark | wood | noah | | ark | wood | lincoln | | ark | canvas | noah | | ark | canvas | davinci | | cabin | wood | noah | | cabin | wood | lincoln | | monalisa | canvas | noah | | monalisa | canvas | davinci | | monalisa | paint | davinci | | jeans | canvas | noah | | jeans | canvas | davinci | | jeans | sewingmachi | NULL | +----------+-------------+---------+ [/snip] You haven't stated the resources required for the project in the query. Try this ... SELECT project.proj, project.rsrc, people.name FROM project LEFT JOIN people ON project.rsrc=people.rsrc WHERE project.rsrc = 'wood' AND project.rsrc = 'canvas' Not tested, but limits people to thos who have only all of the resources. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
