main logo
Subject: Group BY: what's wrong with this?
Author: michael geary
Posted: 2005/03/31 17:39:20
 
View Entire Thread
New Search


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

_______________________________________________
Valentina mailing list
Valentina /AT/ lists DO.T macserve.net
http://lists.macserve.net/mailman/listinfo/valentina

 
©2005 michael geary
<-- Prior Message New Search Next Message -->