[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: Problems when using distinct and hints in a SQR select statement -Reply
- Subject: Re: Problems when using distinct and hints in a SQR select statement -Reply
- From: "Eric A. Eastman" <erice@ontko.com>
- Date: Fri, 21 Mar 1997 14:13:20 -0500
- In-Reply-To: <s33272be.036@mdc.com>
A solution that is a little simpler than the others I have heard is to
use "group by" (and list all columns in the select) instead of
distinct.
Hope this helps,
Eric
------------------------------------------------------------------------
Eric Eastman | Ray Ontko & Co. | Adverbs are endangered; act quickly.
erice@ontko.com | Richmond, IN | http://www.ontko.com/, ftp.ontko.com