Keith Clark wrote:
On Sat, 2009-08-08 at 19:07 -0400, Drew Jensen wrote:
Keith Clark wrote:
Why is the following query too complex to be viewed in the design mode?
SELECT `Date`, weekday( `Date` ) AS `Weekday`,
`Precipitation` AS `Precip`
FROM `kwbo4418_WaterlooWeather2000`.`2005` AS `2005`
WHERE ( weekday( `Date` ) = '4'
OR weekday( `Date` ) = '5'
OR weekday( `Date` ) = '6' )
AND `Precipitation` > 0
Without trying it - change the criteria to 4, 5 and 6 vs `4`, etc.
Hmm, still says Query Too Complex.
Are you using the Native connector? I just constructed something
similar and it takes it - but - and I didn't notice this before (how did
I miss this) it wants to use double quotes... so the SQL turns into
SELECT "Date", weekday( "Date" ), "precipt" FROM "MSIS"."precipitation"
AS "precipitation" WHERE ( "precipt" > 0 AND weekday( "Date" ) = '4' OR
weekday( "Date" ) = '5' OR weekday( "Date" ) = '6' )
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
