Re: outer join question

From: Philippe <parnaud_at_yahoo.com>
Date: Wed, 4 Aug 1999 15:20:29 +0200
Message-ID: <7o9eno$fck$1@concorde.ctp.com>

The correct syntax is :

select a.isin, b.isin
from a,b
where rtrim(a.isin)=rtrim(b.isin(+));

HTH, Philippe

TheKarma_at_yahoo.com wrote in message <7o9ebg$b42$1_at_nnrp1.deja.com>...
>I am having some trouble with outer join and rtrim.
>
>select a.isin, b.isin
>from a,b
>where rtrim(a.isin)=rtrim(b.isin)(+);
>
>gives me "ORA-00933: SQL command not properly ended" error?
>while the same join without the (+) works?
>
>any input will be greatly appreciated.
>
>--VK
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Wed Aug 04 1999 - 08:20:29 CDT