Re: outer join question

Try analog to test User "Scott/Tiger"

select dname,ename from emp,dept
where rtrim(dept.deptno) = rtrim(emp.deptno(+))

It works !

Jean-Felix

TheKarma_at_yahoo.com wrote:

> 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 - 11:09:23 CDT