Re: left outer join

livanojito wrote:

> Hi guys,
> In Oracle 8.* can I have the following condition while doing a left
> outer join
> where rtrim(t1.c1)=rtrim(t2.c2)(+) becuase I got the message "ERROR
> at line 30:
> ORA-00907: missing right parenthesis" and if I code where
> rtrim(t1.c1)=t2.c2(+) then it works.
>
> Thanks

Amazing but true ...

SELECT *
FROM c1, c2
WHERE RTRIM(t1.c1) = RTRIM(t2.c2 (+));

or

SELECT *
FROM c1, c2
WHERE RTRIM(t1.c1 (+)) = RTRIM(t2.c2);

But I can't explain the logic of the syntax.

Daniel Morgan Received on Fri Feb 07 2003 - 14:59:18 CST