In what way is it not working ?
Are you getting an error message, or not
getting the results you expect.
In the latter case, this may be because
you are cancelling the outer join by not
echoing it through all the necessary
points in the WHERE clause.
e.g.
>
> (substr(pcmacaddress,10,2) ||
> sub
Title: RE: Try Again: Outer Join with SUBSTR
SQL> select * from t ;
V
ABCD
WXYZ
SQL> select * from t2 ;
V
--
ABQCDR
WXQYRZ
SQL> select a.v, b.v
2 from t a, t2 b
3 where a.v = substr (b.v(+), 1, 2) || substr (b.v(+), 4, 2) ;
V V
--
ABCD AB