Hi, I had a grid app, with the follow sql sentence
SELECT
orderitens.ordeintesid,
orderitens.orderid,
orderitens.quantity,
orderitens.unitprice,
orderitens.total,
orderitens.unitpricec,
orderitens.totalc,
orderitens.name_code,
orderitens.obs,
products.picture,
products.price,
products.peso
FROM
orderitens INNER JOIN products ON orderitens.name_code = products.name
Grouped by orderitens.name_code
But I want that products.picture, products.price, products.peso shows just one time, no matter the result catch more than one register grouped by orderitens.name_code
For example
orderitens.name_code = fd-001, returns 4 regiter, cause 4 diferents clients order that product, thats ok, but I need just show one time the picture, the price and the weight
and then 4 of the rest fields.
How can I do that? I can’t group by picture too, cause is a blob field and shows symbols not the image if I group for this field.
Any ideas??
Thanks in advance