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. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
