I was wondering how I could perform a join by using a substr of a field or using a column alias of a substr.
I can join on two substr fields with no problem but the command blows up once I add the (+).
ex:
SELECT t.f1, t.f2, t1.f1
FROM table1 t, table1 t1
WHERE substr(t.f1,8) = substr(t1.f1,8)(+)
the other thing I thought was:
SELECT substr(t.f1,8) as test1, substr(t1.f1,8) as test2, t1.f2
FROM table1 t, table1 t1
WHERE test1 = test2(+)
