Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- lnc.LNC_DATA,
- lnc.LNC_DESCRICAO,
- lnc.LNC_VALOR,
- lnc.LNC_SALDO,
- lnc.LNC_RECIBO,
- lnc.LNC_BOM_PARA,
- lnc.LNC_NUM_CHEQUE,
- ctc.CTC_DESCRICAO,
- cxa.CXA_DESCRICAO,
- bxr.BXR_FORMA_RECEBIMENTO,
- ctr.CTR_CODIGO
- from
- LANCAMENTOS_CAIXA lnc
- inner join CENTROS_CUSTOS ctc on ctc.CTC_CODIGO = lnc.CTC_CODIGO
- inner join CAIXAS cxa on cxa.CXA_CODIGO = lnc.CXA_CODIGO
- inner join PLANO_CONTAS pnc on pnc.PNC_CONTA = lnc.PNC_CONTA
- left join CONTAS_RECEBER ctr on ctr.CTR_CODIGO = lnc.CRP_CODIGO
- left join BAIXA_CONTAS_RECEBER bxr on bxr.CTR_CODIGO = ctr.CTR_CODIGO
- union all
- select
- lnc.LNC_DATA,
- lnc.LNC_DESCRICAO,
- lnc.LNC_VALOR,
- lnc.LNC_SALDO,
- lnc.LNC_RECIBO,
- lnc.LNC_BOM_PARA,
- lnc.LNC_NUM_CHEQUE,
- ctc.CTC_DESCRICAO,
- cxa.CXA_DESCRICAO,
- bxp.BXP_FORMA_PGTO,
- ctp.CTP_CODIGO
- from
- LANCAMENTOS_CAIXA lnc
- inner join CENTROS_CUSTOS ctc on ctc.CTC_CODIGO = lnc.CTC_CODIGO
- inner join CAIXAS cxa on cxa.CXA_CODIGO = lnc.CXA_CODIGO
- inner join PLANO_CONTAS pnc on pnc.PNC_CONTA = lnc.PNC_CONTA
- left join CONTAS_PAGAR ctp on ctp.CTP_CODIGO = lnc.CRP_CODIGO
- left join BAIXA_CONTAS_PAGAR bxp on bxp.CTP_CODIGO = ctp.CTP_CODIGO
Add Comment
Please, Sign In to add comment