Sorry Jared I forgot not to include question in the answer > I don't know if this will improve performance but here is an example, use > outer join. > select C.TRC_CUENTA,nvl(A.CTS_NOMBRE,B.CTS_NOMBRE) name > > from transace C, > > ( select CTS_CUENTA,CTS_NOMBRE from cuentaE where cts_TRATAMIENTO = 'IN') A, > > ( select CTS_CUENTA,CTS_NOMBRE from cuentaE where cts_TRATAMIENTO = 'EG') B > > WHERE > > C.TRC_CUENTA = A.CTS_CUENTA(+) AND C.TRC_CUENTA =B.CTS_CUENTA(+) > > > > If you could create a materialized view from this I think this could really > help. Even you could try to create a view. > > If you see when there is records in the second query it will return null > > Juan Carlos Reyes Pacheco > OCP > Database 9.2 Standard Edition ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------