using SUBSTR function in an outer join? [message #19827] |
Thu, 11 April 2002 08:01 |
bechir
Messages: 23 Registered: November 2001
|
Junior Member |
|
|
How to 'outer' a join that includes a SUBSTR function. For example, in T1.col1 = SUBSTR(T2.col1, 1, 4) Where should I put the (+) sign
T1.col1 = SUBSTR(T2.col1, 1, 4) (+) or
T1.col1 = SUBSTR(T2.col1(+), 1, 4)
|
|
|
|
Re: using SUBSTR function in an outer join? [message #19855 is a reply to message #19827] |
Sat, 13 April 2002 16:27 |
Su
Messages: 154 Registered: April 2002
|
Senior Member |
|
|
I dont think the outer join (+) symbol works with an expression. Try with an alias. That is, do alias the expression in SELECT column list and use the same alias name in the outer join expression.
Just like
SELECT COL1, COL2, SUBSTR(COL3,1,2) COLX FROM MYTABLE WHERE COL1 = COLX(+);
Try it out. Guess it works.
Good luck :)
|
|
|
|