[firebase-br] Ajuda com Select/Inner join

[welder]

Bom dia.
Faz assim:

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,
*1ª_TB.C**AMPO_DA_1ª_TB, 2ª_TB.CAMPO_DA_2ª_TABELA, 3ª_TB.CAMPO_DA_3ª_TB*
from tb_c100
inner join tb_c170 on (tb_c100.id = tb_c170.id_c100)
*INNER JOIN 1ª_TB ON (2ª_TB.CAMPO_ID_DA_2ª_TB = 1ª_TB.CAMPO_ID_DA_2ª_TB)*
*.*
*.*
*.*
where tb_c100.num_doc  = 1 and tb_c100.cod_part = '98986'




2011/3/16 Diego Maccari <diegomaccari em ig.com.br>

> 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.
>
> ______________________________________________
> FireBase-BR (www.firebase.com.br) - Hospedado em www.locador.com.br
> Para saber como gerenciar/excluir seu cadastro na lista, use:
> http://www.firebase.com.br/fb/artigo.php?id=1107
> Para consultar mensagens antigas: http://firebase.com.br/pesquisa
>



-- 
Welder Vieira
Técnico em Manutenção e Conectividade
Celular: (63) 8118-6461