[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]
