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
Since the "query designer" does not handle many valid queries, I
consider this tool as obsolete, experimental or waste of time.
I use it to collect the names of tables and fields before I compose the
query in text mode or in a text editor.
Today I found that it can not even group by calculated fields:
SELECT "Forname"||','||"Surname" AS "Patient Info",
[...]
GROUP BY "Patient Info"
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
