Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Can anyone tell me WHY Oracle won't allow sub-queries in outer joins?

547397Nov 21 2006 — edited Nov 22 2006

Hi,

I've recently been tasked with converting a series of InterBase dbs to Oracle.

Many of the queries in the InterBase dbs use sub-queries in outer joins. Oracle won't countenance this (01799 - a column may not be outer-joined to a subquery).

I can get around it using functions but WHY won't Oracle allow this?

SQL Server allows it, InterBase allows it (I don't know about ANSI SQL) but it seems to be a common enough technique...

I'm just curious (and also a little frustrated!).

Thanks in advance,,,

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 20 2006

Added on Nov 21 2006

#general-database-discussions

11 comments

637 views