many-t-many and joins
am 09.07.2005 20:04:05 von Nick HayworthI have a suppliers table and a parts table, linked in a many-to-many
relationship via a suppliers_parts table.
suppliers_parts has a supplier_id field which links to suppliers.id and a
part_id field which links to parts.id
given a list of part id's, how can i retrieve a list of suppliers who carry
ALL the parts?