Hi i got the following query select products.id,v.id as variation_id,products.name as Nombre,c1.name as Categoria,b.name as Marca,tax_rates.name as Impuesto,SUM(COALESCE(vld.qty_available,0)) as Stockactual,MAX(v.sell_price_inc_tax) as PrecioVenta,MIN(v.sell_price_inc_tax) as min_price,MAX(v.dpp_i…

Error group by clause postgresql

ScottR January 5, 2023, 9:16pm 2

Add it to the GROUP BY statement like below

GROUP by products.id, v.id

1 Like