Re: Oracle 8 SQL problem

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 26 Jun 1999 18:48:37 +0200
Message-ID: <930415657.26508.0.pluto.d4ee154e@news.demon.nl>

The correct Oracle syntax is

SELECT DISTINCT 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_ValuesA.ValuesEntryID(+) = T_Entry.EntryID; Assuming ValuesA has missing values.

Hth,

Sybrand Bakker, Oracle DBA

vpanzer_at_my-deja.com wrote in message <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 - 11:48:37 CDT