Hello All!
I just setup a new database for my scheduling software and everything, I
thought was great. Here's the scenario. Using the SQL query below I display
all of the TeeTimes and the customers on there corresponding scheduled days
and time this work fine. Accept when I schedule more than one TeeTime at say
6am it then still displays the schedule correctly but it repeats the 6am
values on all days.
Example1: This is Mondays TeeTimes
TeeTimes Name #Players Email Phone
6:00AM Joe Blow 2 joe@blow 222-555-1111
6:08AM Tom Blow 2 tom@blow 222-555-1111
6:16AM --- --- --- ---
Example 2: This is the same Mondays TeeTimes after I have added 6:00AM
TeeTimes on Tuesday and Wednesday as you can see the schedule is still
accurate but for each day a TeeTime is scheduled it shows another 6:00AM
value. This is where I am stuck. What to Do? HUMMM!
TeeTimes Name #Players Email Phone
6:00AM --- --- --- ---
6:00AM --- --- --- ---
6:00AM Joe Blow 2 joe@blow 222-555-1111
6:08AM Tom Blow 2 tom@blow 222-555-1111
6:16AM --- --- --- ---
Note: The TeeTimes are stored in FixedTeeTimes starting at 6:00AM to 6:08PM
in 7 min. increments with the corresponding TeeID
Here is the SQL query:
SELECT FixedTeeTimes.FixedTeeTimes,
Calendar.CustomerID,
Calendar.Players,
Calendar.TeeDate,
Customers.CustomerID,
Customers.ContactFirstName,
Customers.ContactLastName,
Customers.PhoneNumber,
Customers.EmailAddress
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!
Thanks, Mark :o)
------------------------------------------------------------------------------
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.
