Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT substr(g.nome,0,instr(g.nome,' ',1))||substr(g.nome,instr(g.nome,' ',-1)+1) OPERADOR
- ,a.nropdv
- ,0 SANGRIA_DINHEIRO
- ,0 SANGRIA_MOEDA
- ,b.valor PDV_DINHEIRO
- ,a.dtamovimento
- FROM consinco.fi_tsmovtooperador a
- ,consinco.fi_tsmovtoopedetalhe b
- ,consinco.ge_usuario g
- WHERE b.codoperador = a.codoperador
- AND b.nroempresa = a.nroempresa
- AND b.nropdv = a.nropdv
- AND b.dtamovimento = a.dtamovimento
- AND g.sequsuario = a.codoperador
- AND a.fechado = 'S'
- AND a.nroempresa =1
- AND a.dtamovimento = '01-jul-2024'
- AND b.tipo = 'DIN'
- ORDER BY 2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement