Advertisement
xickoh

total valor factura

Jun 16th, 2018
153
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. SELECT SUM(QUANTxPRECO) AS TOTALSOMADO, idFatura FROM (
  2. SELECT (V.QUANTIDADE * A.PRECO) AS QUANTxPRECO,V.idFatura
  3. FROM VendasArtigos AS V
  4. JOIN Artigo AS A ON
  5. V.idArtigo = A.idArtigo
  6. JOIN Fatura AS F
  7. ON V.idFatura = F.idFatura
  8. ) AS X
  9. GROUP BY idFatura
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement