SQL-92 Join Type

[JaC74]

Does anyone know why Oracle can not support the following join?

select a12.COLUMN_1 COLUMN1,
(a11.COLUMN_1|| a11.COLUMN_2) COLUMN2,
a12.COLUMN_3 COLUMN3,
a12.COLUMN_4 COLUMN4
from L_TABLE a11
join
F_TABLE a12
on
(a11.COLUMN_1||a11.COLUMN_2) = a12.COLUMN_3
where a12.COLUMN_4= 'XXXX'

It doesn't seem to like the concat function in the join criteria. When this is run, we get the dreaded "ORA-03113 End of file" error. However, if the join is done using the where clause, it works fine.

select a12.COLUMN_1 COLUMN1,
(a11.COLUMN_1|| a11.COLUMN_2) COLUMN2,
a12.COLUMN_3 COLUMN3,
a12.COLUMN_4 COLUMN4
from L_TABLE a11,
F_TABLE a12
where (a11.COLUMN_1||a11.COLUMN_2) = a12.COLUMN_3
and a12.COLUMN_4= 'XXXX'


Any insight will be appreciated.

 

[SantaMufasa]

Sorry, JaC, despite our best efforts and greatest wishes, none of us (nor even Oracle personnel) can tell you why Oracle does, or does not, choose to do something.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.