Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- RE.COD_VENDEDOR,
- RE.MESA_COD_MESA,
- re.pp_timestamp,
- re.hora,
- CURRENT_TIMESTAMP AS horaatual,
- DATEADD(DATEDIFF(MINUTE, re.hora, re.pp_timestamp ) MINUTE TO TIME '00:00') AS PERMANENCIA,
- PES1.RAZAO_SOCIAL AS NOME_GARCOM,
- PRE.CONSULTA_LOGO_EMPRESA AS LOGO
- FROM
- REQUISICOES RE
- LEFT OUTER JOIN
- VENDEDORES VEND
- ON (RE.COD_VENDEDOR = VEND.COD_VENDEDOR)
- LEFT OUTER JOIN
- PESSOAS PES1
- ON (PES1.COD_PESSOA = VEND.COD_VENDEDOR)
- LEFT OUTER JOIN
- PARAMETROS_EMPRESA PRE
- ON (RE.COD_EMPRESA = PRE.COD_EMPRESA)
- WHERE
- RE.COD_EMPRESA = 1
- AND RE.COD_REQ = 4;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement