Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> left outer join

left outer join

From: livanojito <lojito_at_mccain.ca>
Date: 7 Feb 2003 11:54:36 -0800
Message-ID: <5058550.0302071154.682915cf@posting.google.com> 





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
Received on Fri Feb 07 2003 - 13:54:36 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US