Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

phpmyadmin fehler rechte unerlaubte mischung, WWWXXXApc, lilo trying to map files from unnamed device 0x0000", Wwwxxxapc, CAM::PDF::Renderer::TextF Fragen, adodb.recordset error '800a0cc1', php save mails as eml, WWWXXXAPC, sqlexpress database file auto-creation error, sqlexpress database file auto-creation error

Links

XODOX
Impressum
Datenschutz

#1: many-t-many and joins

Posted on 2005-07-09 20:04:05 by Nick Hayworth

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?

Report this message