> "Damond Walker" <dwalker@black-oak.com> writes:
> > Returned the following message under MS SQL Server 7.0:
> > ORDER BY items must appear in the select list if SELECT DISTINCT is
> > specified.
>
> Sure looks like that is the consensus answer to the semantics problem...
> guess we should do the same.
Added to TODO:
* require SELECT DISTINCT target list to have all ORDER BY columns
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026