Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

Use of assignment to $[ is deprecated at /usr/local/sbin/apxs line 86. , wwwxxx vim, mysql closing table and opening table, 800c5000, setgid operation not permitted, pciehp: acpi_pciehprm on IBM, WWWXXX.DBF, 078274121, info0a ip, should prodicers of software_based services be held liable or not liable for economic injuries

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