JDBC Sender Query Doubts

[Former Member]

Hello everyone,

I have the next doubt, I'm trying to configure a communication channel JDBC Sender and I'm using the next Query SQL Satetment in communication channel:

select

pec.korden_surt,

dan.cvol_cnat_st1,

dan.cvol_cnat_st2,

dan.mflete,

dan.mpeaje,

pet.icto,

pet.icto_dest,

pet.femb,

pet.fentrega,

pet.fprog,

pet.itransport,

pet.knum_orden,

dan.frec,

pec.kpos_des_os,

dpe.kserv_os,

dan.k_paq_serv_os,

dpe.iflete_peaje

from

vcmae_listado_emb ana,

vcmae_pago_nota_em dan,

scmae_proc_analit pro,

scmae_peticion_sap pet,

scco_peticion_sap pec,

scdo_peticion_sap dpe,

where

ana.itransport = dan.itransport and

ana.ianio = dan.ianio and

ana.ilistado_emb = dan.ilistado_emb and

pet.icto_emb = dan.icto_emb and

pet.femb = dan.femb and

pet.kfolio_nota_emb = dan.kfolio_nota_emb and

pec.icto = pet.icto and

pec.fprog = pec.fprog and

pec.knum_orden = pec.knum_orden and

dpe.icto = pec.icto and

dpe.fprog = pec.fprog and

dpe.knum_orden = pec.knum_orden and

pet.xedo_pet_siic = 'C0' and

pet.xedo_pet_sap = 'C2' or pet.xedo_pet_sap is null

this is working as an INNER JOIN and is working fine, but the problem is that I need to exclude rows from vcmae_listado_emb ana and vcmae_pago_nota_em dan, that exists in table scmae_proc_analit pro, all three tables has the same relation fields, so I think it should work as an OUTER JOIN, but I'm not sure how the sintaxis should be, anyone can help me???, thanks in advance.

Regards,

Julio Cesar

[Former Member]

it worked fine thanks

[VijayKonam]

Julio, Looks like a cleat SQL Query issue. Post it in some SQL forums. This place might not be the right one to get an immediate and accurate answer.

VJ