Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

wwwxxix Buzz, wwwxxxdbgf, ncurses font size, WWWXXX USABLE, WwwXXX MPEG4, WWWXXX BABBAGE WWWXXX, IIS_asps05kj, WWWXXXDOCO, WWW.XXX,GCDMO, Idl Wwwxxx

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