Outer Joins 1

[TimboA]

I need to create a query which extracts data from two tables, something like this :-

select 1.name
,1.code
,2.name
,2.code
from data 1
, data 2
where substr(1.code, 2) = substr(2.code,2) (+)

But, my outer join (+) won't work, I get ORA-00933 SQL Command not properly ended.

I've tried putting in

where (substr(1.code, 2)) = (substr(2.code,2)) (+)

where (substr(1.code, 2) = substr(2.code,2)) (+)

where substr(1.code, 2) = (substr(2.code,2) (+))

with out any success.

Any ideas much appreciated !!!

Tim

 

[sem]

First of all you can not use numbers as table aliases.

The query may be
select a.name
,a.code
,b.name
,b.code
from data a
, data b
where substr(a.code, 2) = substr(b.code(+),2)

 

[TimboA]

Thanks SEM. The table alias as a number thing was a deliberate error (not) in my example just to try and get my problem across. Your advise on the positioning of the (+) has worked though.