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:249813 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
