Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select en.ide_natop,
- enp.prod_xprod,
- en.ide_nnf,
- en.dest_cnpj_cpf,
- en.ide_demi,
- enr.nfref_refnfe
- from edig_nf en
- ,edig_nf_referencia enr
- ,edig_nf_produtos enp
- where en.id_nota_fiscal = enr.id_nota_fiscal
- and en.id_nota_fiscal = enp.id_nota_fiscal
- and enp.prod_xprod not like '%COMPLEM%'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement