RE: Multiple Left Outer Joins

2002-05-20 Thread Alistair Davidson
Hi Bud In SQL Server, it's SELECT T1.*, T2.*, T3.* FROM Table1 T1 LEFT OUTER JOIN table2 T2 ON T1.ID = T2.ID LEFT OUTER JOIN table3 T3 ON T1.ID = T3.ID LEFT OUTER JOIN table4 T4 ON T1.ID = T4.ID WHERE (whatever) Other DB's may differ,

RE: Multiple Left Outer Joins

2002-05-20 Thread Bud
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,

RE: Multiple Left Outer Joins

2002-05-20 Thread Eric J Hoffman
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

RE: Multiple Left Outer Joins

2002-05-19 Thread Eric J Hoffman
We just dealt with this, and here was hows ours ended up: cfquery name=mygetwheels datasource=#fourmy.dsn# Select mycarinfo.id, mycarinfo.carmake, mycarinfo.carmodel, mycarinfo.caryear, mycarinfo.custid, mycarinfo.vin, mycarinfo.mileage, mycarinfo.price, mycarinfo.descrip, mycarinfo.imagethumb,