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 -> Outer Joint Error

Outer Joint Error

From: PMG <pete_g_at_2xtreme.net>
Date: Thu, 03 Jun 1999 05:18:31 GMT
Message-ID: <3756107A.8E494573@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 - 00:18:31 CDT

Original text of this message

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