[thelist] MYSQL: getting distinct dates from a DATETIME field

[rudy]

> <tip type="SQL" author="Joshua Olson">
> If your query has a GROUP BY clause, the SELECT clause 
> can only contain aggregated columns (SUM, MIN, COUNT, etc) 
> or the columns that are in the GROUP BY clause.

once again i must be a nitpicker, sorry

change the word "or" in the above sentence to "and" --
any difference in meaning?

what about "and/or"?  

and must the SELECT list contain all the columns in the GROUP BY,
or can it contain only some of them?  none of them?


forget for a moment that you and i know the syntax, and
try to see it through the eyes of someone who does not

... ESPECIALLY someone who has been taught the 
non-standard mysql proprietary extension


rudy