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,
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,
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
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,
4 matches
Mail list logo