[thelist] [mysql] count query

kris burford kris at midtempo.net
Thu Sep 11 11:21:59 CDT 2003


>you cannot have the WHERE clause after the GROUP BY
>
>in kris' example, the GROUP BY works as desired in mysql,
>because presumably the relationship between f.folder and
>f.id column values is one to one
>
>rudy

ahh! now it works! moving the order of the group by/where clause has sorted it.

thanks all.

kxx



More information about the thelist mailing list