Re: trying to convert sql left outer join to oracle

From: Thomas Gaines <Thomas.Gaines_at_noaa.gov>
Date: Fri, 27 Dec 2002 17:19:31 -0700
Message-ID: <3E0CEE13.9ED43D94@noaa.gov>

Greg -

You should have looked more carefully at Frank's example. You'll note that the "as" in his working example comes BEFORE the "from". Yours didn't.

Syntax is important! Don't moan and groan just because you don't follow the rules!

Greg wrote:

> My mistake, if you do the following you see the behavior I recall from
> my formative days:
>
> select * from sys.dual as xxx
>
> MS Access allows this, Oracle doesn't seem to.
Received on Fri Dec 27 2002 - 18:19:31 CST