Group BY: what's wrong with this?

[michael geary]

using V4MD:

sql = select authors.* from authors GROUP BY authors.email ORDER BY 
authors.lastName asc

results in the error:
"In the SELECT clause you can use only fields listed in the GROUP BY 
and aggregative functions."

In MySQL this query works just fine. What am I doing wrong in Valentina?

thanks,

michael