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:
Last updated: