leonam-carlos

SQL para Consultoria

Jan 25th, 2019
203
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.49 KB | None | 0 0
  1. SELECT
  2.   VENDAS.ECF_NUMERO,
  3.   VENDAS.ECF_DATA,
  4.   VENDEDOR.VEN_APELIDO AS VENDEDOR_NOME,
  5.   VENDAS.VND_DTMODIFICA,
  6.   VENDAS.VND_HRMODIFICA,
  7.   VENDAS.VND_MODIFICADO AS MODIFICADOR_NOME,
  8.   VENDAS.ECF_TOTAL,
  9.   VENDAS.ECF_DESCONTO,
  10.   VENDAS.VND_TOTAL_LIQ
  11. FROM
  12.   VENDAS
  13.   INNER JOIN VENDEDOR ON (
  14.     VENDAS.VENDEDOR_ID = VENDEDOR.VEN_CODIGO
  15.   )
  16. WHERE
  17.   VENDAS.ECF_DATA >= '2/1/2018'
  18.   AND VENDAS.ECF_DATA <= '2/28/2018'
  19. ORDER BY
  20.   VENDAS.ECF_DATA,
  21.   VENDAS.ECF_NUMERO
Advertisement
Add Comment
Please, Sign In to add comment