I never saw the original question, but from your response below, maybe you just need a UNION query?
SELECT * FROM main m JOIN companies c ON c.companyid=m.manufacturerid UNION SELECT * FROM main m JOIN companies c ON c.companyid=m.publisherid Cheers, Kris > > FROM main m JOIN companies c1 on (c1.companyid = > > m.manufarturerid and/or c2.companyid = m.publisherid > > That will only return one company name from the companies table though, I > need multiple company names returned. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:249821 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
