Can anyone help me with this query convert?
select rl.Id, rl.IdTestataListino, rl.IdProdotto, rl.Prezzo, pr.Descrizione, count(*) as N_Ordini
from RigaListino as rl
left join RigaOrdine as ord
on rl.IdProdotto = ord.IdProdotto
left join Prodotto as pr
on pr.Id = rl.IdProdotto
where rl.IdTestataListino = 2
group by rl.Id, rl.IdTestataListino, rl.IdProdotto, rl.Prezzo, pr.Descrizione
order by N_Ordini
Laxmidhar SahooPosted Jul 6, 2020, 5:16 AM