You see on the join stuff...they all are being done to the table mycarinfo...So table 2,3, and 4 are all being joined on table 1.
We run on SQL, and if we used LEFT OUTER JOIN on each instance, it crapped. Couldn't figure out why, but this works swimmingly and returns the info we need if there is related info in the tables. Have fun! Eric -----Original Message----- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 6:23 AM To: CF-Talk Subject: RE: Multiple Left Outer Joins 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 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
