Select and Group by

This is more of a challenge than a need, I have never worked out how to / if you can define a query within the query builder that includes a single “group by”

Always done a workaround/ custom query in the past but surely something as basic as this can be done from the GUI?

So I have two tables, “models” and “productimages” linked on a primary/ foreign key “modelid”

The query i want is::

select models.*, productimages.imagename from models 
left join productimages on productimages.modelid = models.modelid 
group by models.modelid 
Community Page
Last updated: