Re: Oracle 8 SQL problem

Oracle does not support the Access join syntax (LEFT, RIGHT, INNER, etc.)

Oracle uses a plus sign to perform a left join in the WHERE clause instead of the FROM. This might work. If not switch the fields (I ran your query thru
my Q&D Access to Oracle converter and it is a little buggy still).

SELECT DISTINCTROW T_Entry.EntryID, T_Entry.EntryPageID, T_Entry.EntryText, T_Entry.EntryUseFlag, T_Entry.EntryAddby, T_ValuesA.ValuesValue FROM T_Entry, T_ValuesA
WHERE T_Entry.EntryID (+) = T_ValuesA.ValuesEntryID;

HTH,
-Dave
dcarr<at>gr<dot>com

vpanzer_at_my-deja.com wrote in article <7l2jqa$vm4$1_at_nnrp1.deja.com>...
> The following SQL-Statement works fine in MS Access, but produces an
> Error-Msg when running on Oracle (within an
> ASP-Page that is connected to Oracle 8).
>
> TNX in advance for any help !
> Volker
>
> SELECT DISTINCTROW T_Entry.EntryID, T_Entry.EntryPageID,
> T_Entry.EntryText, T_Entry.EntryUseFlag,
> T_Entry.EntryAddby, T_ValuesA.ValuesValue
> FROM T_Entry LEFT JOIN T_ValuesA ON T_Entry.EntryID =
> T_ValuesA.ValuesEntryID;
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>
Received on Sat Jun 26 1999 - 15:52:32 CDT