Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT estabelecimento.nome AS estabelecimento
- , notafiscal.dtemissao
- , notafiscal.dtentrega
- , notafiscal.numpedido
- , notafiscal.tipoparceiro AS tipoparceiro
- , (CASE WHEN notafiscal.tipoparceiro = 'C' THEN cliente.nome WHEN tipoparceiro = 'F' THEN fornecedor.nome WHEN tipoparceiro = 'E' THEN e.nome ELSE NULL END) AS parceiro
- , notafiscal.numnotafis AS notafiscal
- , notafiscal.serie
- , (natoperacao.natoperacao || ' - ' || natoperacao.descricao) AS natoperacao
- , notafiscal.totalliquido
- , notafiscal.status
- FROM notafiscal
- LEFT JOIN cliente ON (notafiscal.tipoparceiro = 'C' AND notafiscal.codparceiro = cliente.codcliente)
- LEFT JOIN fornecedor ON (notafiscal.tipoparceiro = 'F' AND notafiscal.codparceiro = fornecedor.codfornec)
- LEFT JOIN estabelecimento e ON (notafiscal.tipoparceiro = 'E' AND notafiscal.codparceiro = e.codestabelec)
- INNER JOIN estabelecimento ON (notafiscal.codestabelec = estabelecimento.codestabelec)
- INNER JOIN natoperacao ON (notafiscal.natoperacao = natoperacao.natoperacao)
- WHERE notafiscal.operacao NOT IN ('CP','TE')
- AND notafiscal.codestabelec = 2
- ORDER BY notafiscal.dtentrega, estabelecimento.nome, notafiscal.numnotafis
Add Comment
Please, Sign In to add comment