Advertisement
Guest User

Untitled

a guest
Oct 16th, 2018
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.64 KB | None | 0 0
  1. SELECT
  2.    RE.COD_VENDEDOR,
  3.    RE.MESA_COD_MESA,
  4.    re.pp_timestamp,
  5.    re.hora,
  6.    CURRENT_TIMESTAMP AS horaatual,
  7.    DATEADD(DATEDIFF(MINUTE, re.hora, re.pp_timestamp ) MINUTE TO TIME '00:00') AS PERMANENCIA,
  8.    PES1.RAZAO_SOCIAL AS NOME_GARCOM,
  9.    PRE.CONSULTA_LOGO_EMPRESA AS LOGO
  10. FROM
  11.    REQUISICOES RE
  12.    LEFT OUTER JOIN
  13.       VENDEDORES VEND
  14.       ON (RE.COD_VENDEDOR = VEND.COD_VENDEDOR)
  15.    LEFT OUTER JOIN
  16.       PESSOAS PES1
  17.       ON (PES1.COD_PESSOA = VEND.COD_VENDEDOR)
  18.    LEFT OUTER JOIN
  19.       PARAMETROS_EMPRESA PRE
  20.       ON (RE.COD_EMPRESA = PRE.COD_EMPRESA)
  21. WHERE
  22.    RE.COD_EMPRESA = 1
  23.    AND RE.COD_REQ = 4;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement