Thanks, Bud
I actually do want all the TeeTimes from the FixedTeeTime Table but I don't
want the TeeID values from the Calendar table this is where I am confused
should I redesign my tables?
-Mark :o)
----- Original Message -----
From: Bud <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, September 10, 2000 12:49 AM
Subject: Re: Database Blunders
> 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.
>
------------------------------------------------------------------------------
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.
