many-t-many and joins

I 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?
Nick Hayworth [ Sa, 09 Juli 2005 20:04 ] [ ID #872587 ]
Datenbanken » comp.databases.postgresql.sql » many-t-many and joins

Vorheriges Thema: User-defined tables
Nächstes Thema: Function that creates views