Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- declare @idFatura int = 1 /*Escolher qual fatura calcular*/
- select idFatura, sum(a.preco * v.quantidade)
- from vendasArtigos v join
- artigos a
- on v.idArtigo = a.idArtigo
- WHERE idFatura = @idFatura;
- OU PARA CALCULAR TODAS
- select idFatura, sum(a.preco * v.quantidade)
- from vendasArtigos v join
- artigos a
- on v.idArtigo = a.idArtigo
- GROUP BY idFatura
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement