Outer Join -- SQL

[amerbaig]

Am I allowed to use oute-join like this

Select Normalised_event_ID, A_Party_Id, B_Party_Id, Full_Path, Name from Normalised_event, tblOperator where Substr(B_Party_Id,1,length(code)) (+) = code and trim(full_path) = '107' order by Normalised_event_ID

It give me error ORA--00920 Invalid Operator

 

[SpiritOfLennon]

Sem, it should work. I figured that this had already been tried and discarded. This would be the full SQL
Select Normalised_event_ID,
A_Party_Id,
B_Party_Id,
Full_Path,
Name
from
Normalised_event,
tblOperator
where
B_Party_Id(+)like code||'%'
and trim(full_path) = '107'
order by Normalised_event_ID
SOL
The best thing about banging your head against a wall is when you stop.