Hehe, well, my SQL statements usually are a chain of LEFT JOINs when I do
something like this. I was just trying to stick to his SQL statement.
Justin Kidman
-----Original Message-----
From: Jeremy Allen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 06, 2000 10:42 AM
To: [EMAIL PROTECTED]
Subject: RE: OUTER JOIN w/more than 2 tables
You do not have to use the OUTER keyword either you can
just do RIGHT JOIN or LEFT JOIN or FULL JOIN :)
Jeremy
-----Original Message-----
From: Justin Kidman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 06, 2000 1:27 PM
To: '[EMAIL PROTECTED]'
Subject: RE: OUTER JOIN w/more than 2 tables
Do this all the time, n-table joins, just need to use () well.
SELECT FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID,
Customers.CustomerID, Customers.ContactFirstName, Customers.ContactLastName,
Customers.PhoneNumber, Customers.EmailAddress
FROM oj Calendar RIGHT OUTER JOIN (FixedTeeTimes ON
Calendar.TeeID = FixedTeeTimes.TeeID RIGHT OUTER JOIN Customers) ON
Customers.CustomerID = Calendar.CustomerID
Use the () to left if you are using a LEFT OUTER JOIN.
Justin Kidman
-----Original Message-----
From: Mark Adams [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 06, 2000 10:10 AM
To: [EMAIL PROTECTED]
Subject: OUTER JOIN w/more than 2 tables
Hello All!
"OUTER JOIN" with 3 tables? I have tried this many ways and I keep getting
errors. If I set up a query with 3 or more tables everything works fine
until I change the "INNER JOIN" to an "OUTER JOIN" So I tried setting up
just 2 tables with an "OUTER JOIN" everything works great but if I add
another table it errors again. AHHHH!
The queries are below.
What am I missing?
Any help is appreciated.
Mark :o)
<!-----This one works fine----->
SELECT FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID
FROM {oj Calendar RIGHT OUTER JOIN FixedTeeTimes ON Calendar.TeeID =
FixedTeeTimes.TeeID }
<!-----But I need data from 3rd table so I add this and it errors out----->
SELECT FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID,
Customers.CustomerID, Customers.ContactFirstName, Customers.ContactLastName,
Customers.PhoneNumber, Customers.EmailAddress
FROM Customers, {oj Calendar RIGHT OUTER JOIN FixedTeeTimes ON
Calendar.TeeID = FixedTeeTimes.TeeID }
WHERE Customers.CustomerID = Calendar.CustomerID
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
