Select time not in 3 Sessions in another table

Question

trying to select count when the fColorGridGenAt is not between Session A = 9.00 - 10.00
Session B = 14.00 - 15.00 & Session C = 17.00 - 18.00

table 1 = tColorGridSession
table 2 = tColorGridDailyGenLog

fColorGridStartTime = time(7)
fColorGridGenAt = datetime

but the following had error,

Select COUNT(tcgs.fColorGridGenLogID) FROM tColorGridSession tcgs, tColorGridDailyGenLog tcg 
WHERE (tcgs.fColorGridGenAt NOT BETWEEN tcgs.fColorGridStartTime AND tcgs.fColorGridEndTime 
WHERE tcgs.fColorGridSessionName = 'A') AND
(tcgs.fColorGridGenAt NOT BETWEEN tcgs.fColorGridStartTime AND tcgs.fColorGridEndTime 
WHERE tcgs.fColorGridSessionName = 'B') AND
(tcgs.fColorGridGenAt NOT BETWEEN tcgs.fColorGridStartTime AND tcgs.fColorGridEndTime 
WHERE tcgs.fColorGridSessionName = 'C')

Answer 1

I don't understand your query.

There are a lot of error's in your query.

• Where did you Equate tcgs and tcg tables. (i.e joined the tables on a column)
• Why do you use "tColorGridDailyGenLog tcg" table when you haven't used it any where.
• There are syntactical errors in your query. Why are you using WHERE keyword multiple times.

I tried a query but it seems that it is misleaded by insufficient information.

Please clarify on these issues so that we can provide a solution. Provide table create and sample data scripts.

---

Planet Earth is at risk. Global warming is on a high tide.
Take Responsibility. Plant Trees. Keep your City Clean and Green.

Mark all Helping Posts and Close your Threads. Keep the Forum Green.
 - Arun Kumar Allu