Help with the request, I need to group this work request by the
materials.id column. Now, adding the last line displays an error. How to do it right?
SELECT materials.sname, materials.id, records.id, usematerials.sell_price, usematerials.material_count, clients.sname, records.sdate, usematerials.material_discount, (usematerials.sell_price*usematerials.material_count) as sell_total_price FROM materials INNER JOIN (usematerials INNER JOIN (records INNER JOIN clients ON records.id_client = clients.id ) ON usematerials.id_record = records.id ) ON materials.id = usematerials.id_material ORDER BY materials.id GROUP BY materials.id <- not working
Error: Your query does not contain the specified expression "sname" as part of an aggregate function.
Structure: materials, usematerials, records, clients