No, the "oj" is the default OUTER JOIN for ODBC. If you apply an OUTER JOIN
with SQL Builder in CF Studio it inserts the "oj" so I just left it there
its probably redundant.
Here is the latest error,
<!-----Error Message----->
Error Diagnostic Information
ODBC Error Code = S1000 (General error)
[Microsoft][ODBC Microsoft Access Driver] Join expression not supported.
I'm just not getting this stuff. It seems so easy yet its irritating the
h#$%@l out of me. AHHH!
HELP!
-Mark
----- Original Message -----
From: Jeremy Allen <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 06, 2000 12:00 PM
Subject: RE: OUTER JOIN w/more than 2 tables
> What is the "oj" right after the FROM?
>
> Shouldnt that not be there..? Or is oj a
> table and your aliasing it to Calendar??
>
> Jeremy
>
> -----Original Message-----
> From: Mark Adams [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 06, 2000 2:17 PM
> 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.
>
>
>
> <!-----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/[email protected]/
> > 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/[email protected]/
> > 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/[email protected]/
> 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/[email protected]/
> 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/[email protected]/
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.
