Hi,

Can i use the GROUP BY function in a mysql query to group by 2 fields at the same time? So not group by x, then by y, but group by x and y at the same time?

thanks!

Matt

group by field, field

of course

select x,y
from z
group by x,y

Just remember that you must output only the fields you want to group