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 -> Re: Oracle 8 SQL problem

Re: Oracle 8 SQL problem

From: PR1999 <pr1999_at_aol.com>
Date: 27 Jun 1999 07:42:16 GMT
Message-ID: <19990627034216.23210.00001301@ng-fk1.aol.com>


Access SQL syntax is a little different than Oracle's...... Change your Join statement into the where clause in oracle using the proper operator (+)=

select t_entry.*.....
from t_entry, t_valuesa
where t_entry.entryID (+)= t_valuesA.valuesvalue;

Hope this may help you! Received on Sun Jun 27 1999 - 02:42:16 CDT

Original text of this message

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