You could prolly do them as left joins so that you get a record even if some of the elements don't exist...
Eric -----Original Message----- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Tuesday, 15 August 2006 06:48 To: CF-Talk Subject: Multiple joins between the same tables. I have done this before so I know it can be done, but I can't remember how. I have a table of item details that relates to a table of companies. The first table has fields like "ManufacturerID" and "PublisherID" and these fields link to company names in the companies table. The problem is you cant just do a simple... FROM main m JOIN companies c1 on (c1.companyid = m.manufarturerid) JOIN companies c2 on (c2.companyid = m.publisherid) But I can't remember how you do join these. Any help? -- Jay -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.405 / Virus Database: 268.10.10/418 - Release Date: 14/08/2006 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249889 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
