[firebase-br] Ajuda com Select/Inner join

Diego Maccari diegomaccari em ig.com.br
Qua Mar 16 08:33:15 -03 2011


Pessoal eu tenho o seguinte Select/ Inner Join

select tb_c170.id, tb_c170.reg, tb_c170.num_item, tb_c170.cod_item, 
tb_c170.descr_compl,
tb_c170.qtd, tb_c170.unid, tb_c170.vl_item, tb_c170.vl_desc, 
tb_c170.ind_mov, tb_c170.cst_icms, tb_c170.cfop, tb_c170.cod_nat, 
tb_c170.vl_bc_icms,
tb_c170.aliq_icms, tb_c170.vl_icms, tb_c170.vl_bc_icms_st, tb_c170.aliq_st, 
tb_c170.vl_icms_st, tb_c170.ind_apur, tb_c170.cst_ipi, tb_c170.cod_enq,
tb_c170.vl_bc_ipi, tb_c170.aliq_ipi, tb_c170.vl_ipi, tb_c170.cst_pis, 
tb_c170.vl_bc_pis, tb_c170.aliq_pis, tb_c170.quant_bc_pis, 
tb_c170.aliq_pis_reais,
tb_c170.vl_pis, tb_c170.cst_cofins, tb_c170.vl_bc_cofins, 
tb_c170.aliq_cofins, tb_c170.quant_bc_cofins, tb_c170.aliq_cofins_reais, 
tb_c170.vl_cofins,
tb_c170.cod_cta, tb_c170.id_c100, tb_c100.id, tb_c100.reg, tb_c100.ind_oper, 
tb_c100.ind_emit,
tb_c100.cod_part, tb_c100.cod_mod, tb_c100.cod_sit, tb_c100.ser, 
tb_c100.num_doc, tb_c100.chv_nfe, tb_c100.dt_doc, tb_c100.dt_e_s, 
tb_c100.vl_doc,
tb_c100.ind_pgto, tb_c100.vl_desc, tb_c100.vl_abat_nt, tb_c100.vl_merc, 
tb_c100.ind_frt, tb_c100.vl_frt, tb_c100.vl_seg, tb_c100.vl_out_da, 
tb_c100.vl_bc_icms,
tb_c100.vl_icms, tb_c100.vl_bc_icms_st, tb_c100.vl_icms_st, tb_c100.vl_ipi, 
tb_c100.vl_pis, tb_c100.vl_cofins, tb_c100.vl_pis_st, tb_c100.vl_cofins_st
from tb_c100
inner join tb_c170 on (tb_c100.id = tb_c170.id_c100)
where tb_c100.num_doc  = 1 and tb_c100.cod_part = '98986'

Este código está correto, mas preciso inserir no resultada desta SQL mais 
algumas colunas de um 3º tabela
como posso fazer isso??

Att

Diego M. 





Mais detalhes sobre a lista de discussão lista