On 5/19/02, Eric J Hoffman penned: >LEFT OUTER JOIN mycarinfo on mycust.id = mycarinfo.custid >JOIN mycarmodel on mycarmodel.id = mycarinfo.carmodel >JOIN mycarmake on mycarmake.id = mycarinfo.carmake >WHERE blah >/cfquery > >Does that make sense? We are joining onto multiple tabels from our main >one, mycarinfo, and grabbing all associated records from the other >tables if I remember right already....
That's basically what I want to do, but the associated tables may not have records in them. That's why I need the LEFT OUTER JOIN. What you did looks basically the same as joining table 1 to table 2, table 2 to table 3, etc, but without the parentheses. I'll give it a shot. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
