outer join [message #19562] |
Thu, 28 March 2002 06:48 |
LI810
Messages: 25 Registered: February 2002
|
Junior Member |
|
|
May I use the outer h=join on the part of the field like that ?
substr(f.ACC_I,2,5)= substr(a.ACC_I,4,5) (+)
Stored procedure compiled without errors. But I have the run-time error when I include the statement in the condition clause of the query.
Thank you,
|
|
|
Re: outer join [message #19577 is a reply to message #19562] |
Thu, 28 March 2002 21:31 |
Somu
Messages: 24 Registered: February 2000
|
Junior Member |
|
|
Hi,
Could you give us the exact error number or the error you are getting. so that i can help you out.
|
|
|
|
Re: outer join [message #19670 is a reply to message #19596] |
Wed, 03 April 2002 07:03 |
LI810
Messages: 25 Registered: February 2002
|
Junior Member |
|
|
Sorry,
but you are not right.
I found the answer. You can use functions , just place (+) in the right location.
substr(field(+),1,5) will work.
|
|
|