Re: Outer Joint Error

From: Reiner Neumann <reiner.neumann_at_messe.de>
Date: Thu, 3 Jun 1999 09:21:41 +0200
Message-ID: <7j5aej$9r7$1@mail.messe.de>

Try this:

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

Reiner

PMG <pete_g_at_2xtreme.net> schrieb in im Newsbeitrag: 3756107A.8E494573_at_2xtreme.net...
> 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 - 02:21:41 CDT