On 9/9/00, Mark Adams penned:
>FROM (FixedTeeTimes LEFT OUTER JOIN Calendar ON FixedTeeTimes.TeeID
>= Calendar.TeeID ) LEFT OUTER JOIN Customers ON Customers.CustomerID =
>Calendar.CustomerID
>
>
>ORDER BY FixedTeeTimes
>
>Ok, I know its probably easy, right in front of me and all that, but my mind
>is melting now. HELP!
I think if you make the first join an inner join it will work. The
left outer is returning ALL records from the FixedTeeTimes table.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
------------------------------------------------------------------------------
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.
