Hi Folks !
I have the cliché situation: Orders belongsToMany Products through OrderItems.
And also Orders belongsTo Customers
I am trying to get a resultSet with order.date, order.customer.name and a calculate field order.total which
means (order.product.price * order.order_item.quantity)
I'have tried with ->matching('Products') with however I've got duplicated order entities
Is there any way to do that?
Thanks in advance !