Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

TheboL.wwwxxxxx, WWWXXXAPC , wwwxxn.xsss, wwwxxxapc, WWWXXX.VCBA, wwwxxx vba, wwwxxxdoco, Wwwxxx.APC, wwwxxx CN2, can't locate feature.pm in @inc (@inc contains

Links

XODOX
Impressum

#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