SELECT status.caption, SUM(orders.amout)
FROM orders
JOIN status ON orders.status_id = status.id
GROUP BY status.id
How can i execute such SELECT query and output results to client using qxorm?
I see only one way to solve this: create business object for this and fetch all data using qx_query into this object manually.