oracle joins using functions

[julianbar]

I have been trying to join two tables A and B

I want to join them by the substr(fielda,1,2)=substr(fieldb1,2)

I want to include all records in table A, even when there is no match.

Can I use a plus sign using functions.

When I try this it works
substr(fielda,1,2)=substr(fieldb1,2)

However this does not work
substr(fielda,1,2)=substr(fieldb1,2)(+)


???

Thanks

 

[sem]

Try this:
substr(fielda,1,2)=substr(fieldb(+),1,2)