Re: Outer Joint Error

From: Geoff White <whiteg_at_ccis.adisys.com.au>
Date: Thu, 03 Jun 1999 16:37:50 +0800
Message-ID: <37563EDE.BC41293A@ccis.adisys.com.au>

I found that this worked as I expected:

select something
from tableA, tableB
where rtrim(a.name) = rtrim(b.name(+))

HTH
Geoff

PMG wrote:

> I get an error msg, "ORA-00933: SQL command not properly ended" when I
> try to execute the following outer join. Can somebody explain why using
> a function in the where clause prevents the use of an outer join? Or
> better yet, how to get around this problem.
>
> select something
> from tableA, tableB
> where rtrim(a.name) = rtrim(b.name) (+)
>
> TIA
>
> Pete
Received on Thu Jun 03 1999 - 03:37:50 CDT