Hello, good everyone!
I have the following problem, is a query in oracle, of the query I can not do the last part where there is like a left join but a not equal in the column COD_DIRECC_TRANSF , how could I do it
select cust.COD_DIRECC_TRANSF , cust2.COD_DIRECC_TRANSF as COD_DIRECC_TRANSF_cust
FROM HSTOWN.FT_CUSTODIA_CH cust,
HSTOWN.LK_CUENTA_CH lk,
HSTOWN.LK_TIPO_EVENTO_CH te,
HSTOWN.FT_CUSTODIA_CH cust2,
HSTOWN.LK_CUENTA_CH lk2
WHERE cust.cod_cuenta = lk.cod_cuenta
AND lk.version_vigente = 1
AND cust.tipo_evento = te.tipo_evento(+)
AND cust.id_corrida = pIdCorrida
AND cust.nro_operacion = cust2.nro_operacion(+)
AND cust.fecha_operacion = cust2.fecha_operacion(+)
AND CUST.COD_CHEQUE = cust2.cod_cheque(+)
AND CUST.COD_DIRECC_TRANSF <> CUST2.COD_DIRECC_TRANSF(+)
