Look good to me. What's wrong? You can use the same table multiple times or even joing a table on itself. I personally would use a LEFT JOIN, but it depends what your goal is.
Terry >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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:249822 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
