SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01799: a column may not be outer-joined to a subquery

420265Jun 30 2004 — edited Sep 23 2004

SELECT t1."id" "c_5" FROM s_00000000B7 t1 LEFT OUTER JOIN s_00000000GJ t2 ON t2."i_00000002TT" = ( SELECT MAX(a10t2."i_00000002TT") FROM s_00000000GJ a10t2 )

This query returns following error on Oracle 9.2.0.4:
ORA-01799: a column may not be outer-joined to a subquery

Why?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 21 2004

Added on Jun 30 2004

9 comments

4,863 views