outer join query help!

[mkey]

HI All,
My script looks something like this.

select a.name,b.filename
from table_a t1, table_b t2
where substr(a.name,1,8) (+) = substr(b.filename,1,8)

Obviously right now I'm getting an error using (+) this way. I need all the name records even if they don't match table_b filename. Any thoughts on this will help!
Thank you in advance!

 

[Guest_imported]

You have to put the (+) next to the column, like:
select a.name,b.filename
from table_a t1, table_b t2
where substr(a.name(+),1,8) = substr(b.filename,1,8)

 

[mkey]

Sorry but I don't think that will work! I'm getting a ORA-01719 error!

 

[mkey]

oops! sorry it seems like its working!
thank you!