>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