Doh, I messed up the ()... /bonk Justin.
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
That is the () setup I would use on LEFT JOINs, I don't use RIGHT JOINs much
because they feel backwards to me.
Justin Kidman
-----Original Message-----
From: Mark Adams [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 06, 2000 11:17 AM
To: [EMAIL PROTECTED]
Subject: Re: OUTER JOIN w/more than 2 tables
I tried it and I keep getting this error. Its the same error I was getting
before. I must be missing something.
:o(
<!-----Error Message----->
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in JOIN operation.
-Mark
----- Original Message -----
From: Justin Kidman <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 06, 2000 10:27 AM
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.Fixed
TeeTimes, 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.
