[PLUG] Re: SQL Syntax

[Mark A. Turner]

> On Mon, 6 Nov 2006 09:49:11 -0800
> "Mark A. Turner" <turner at glsuite.com> wrote:
> 
> > The only time the ORDER BY Clause is limited to the result set is
when
> > your using a SELECT DISTINCT <COLUMN NAME>, other wise you have
access
> > to any tables used in the query.
> >
> 
> the original poster is using 'select distinct <column name>,' i'm
> willing to cop to not catching this the first time; i suggested '
order
> by' not realizing that they couldn't access the order by column.

I am guilty of the same slight overlook.

-Mark