On 02-Jun-2014 12:57 -0500, Hoteltravelfundotcom wrote:
The case here is that I am using query/400 to get data and there are
some duplicate part #'s we are only interested in 1 part# not the

So I thought to use the SQL select distinct. <<SNIP>>

"Depending on what is the current Query Definition, the Query/400 feature may be able effectively to produce a DISTINCT result. Not having an actual well-described scenario... difficult to know what might be better than the posited approach of deferring to the SQL."

Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2015 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact