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(+)
