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/[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.
