Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT MP.DTMOVPROD,TM.TIPOMOV,MP.CODNAT,MP.CODVENDA,MP.CODCOMPRA,MP.CODPROD,eq.descprod,eq.codfisc,MP.TIPOMOVPROD,MP.DOCMOVPROD,MP.CODALMOX,MP.CODLOTE,MP.QTDMOVPROD,MP.PRECOMOVPROD,MP.ESTOQMOVPROD,MP.SLDMOVPRODAX,EQ.TIPOPROD,MP.CUSTOMPMMOVPRODAX,MP.SLDMOVPROD,MP.CUSTOMPMMOVPROD,MP.CODMOVPROD,MP.CODEMPTM,TM.CODEMP,MP.CODFILIALTM,TM.CODFILIAL,(MP.sldmovprod*MP.CUSTOMPMMOVPROD) SALDO,CLI.NOMECLI CODTIPOMOV FROM EQMOVPROD MP
- INNER JOIN EQPRODUTO eq ON mp.codprod = eq.codprod
- INNER JOIN vdvenda vd ON mp.codvenda=vd.codvenda
- INNER JOIN vdcliente cli ON vd.codcli = cli.codcli
- LEFT JOIN EQTIPOMOV TM ON TM.CODEMP = MP.CODEMPTM
- WHERE MP.CODFILIALTM=TM.CODFILIAL AND MP.CODTIPOMOV=TM.CODTIPOMOV AND tipoprod='P' AND mp.codcompra IS NULL
- UNION ALL
- SELECT MP.DTMOVPROD,TM.TIPOMOV,MP.CODNAT,MP.CODVENDA,MP.CODCOMPRA,MP.CODPROD,eq.descprod,eq.codfisc,MP.TIPOMOVPROD,MP.DOCMOVPROD,MP.CODALMOX,MP.CODLOTE,MP.QTDMOVPROD,MP.PRECOMOVPROD,MP.ESTOQMOVPROD,MP.SLDMOVPRODAX,EQ.TIPOPROD,MP.CUSTOMPMMOVPRODAX,MP.SLDMOVPROD,MP.CUSTOMPMMOVPROD,MP.CODMOVPROD,MP.CODEMPTM,TM.CODEMP,MP.CODFILIALTM,TM.CODFILIAL,(MP.sldmovprod*MP.CUSTOMPMMOVPROD) SALDO,FORN.RAZFOR CODTIPOMOV FROM EQMOVPROD MP
- INNER JOIN EQPRODUTO eq ON mp.codprod = eq.codprod
- INNER JOIN cpcompra cp ON mp.codcompra = cp.codcompra
- INNER JOIN cpforneced forn ON cp.codfor =forn.codfor
- LEFT JOIN EQTIPOMOV TM ON MP.CODEMPTM=TM.CODEMP
- WHERE MP.CODFILIALTM=TM.CODFILIAL AND MP.CODTIPOMOV=TM.CODTIPOMOV AND tipoprod='P' AND mp.codvenda IS NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement