Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- EXISTS(
- SELECT
- id_venda_cf
- FROM
- venda_cf AS v
- INNER JOIN movimento_venda_terminal AS mv ON (
- v.id_movimento_venda_terminal = mv.id_movimento_venda_terminal
- )
- WHERE
- v.id_cliente = CAST(16692656 AS BIGINT)
- AND v.cancelada = 'N'
- AND mv.id_empresa NOT IN (
- SELECT
- id_empresa
- FROM
- sis_empresa se
- WHERE
- se.guid_empresa IN (
- '428FE6893116415A9E8492A4E4389FDC',
- '58F6191039094B118F8FA138D3571059',
- 'A17799B432C14F04AAB0278CEE9F3AB1',
- 'AE167ECCFDBF4434A7688C9B5EFFE988',
- 'B532F21B0B9D41B29EAE1FE0B223A805',
- 'F2CA336B72CC45C9B7A504374B44FA77',
- 'F75A07CBC0354BCF8E88411CF5F1B0D0'
- )
- )
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement