Yes, they will but in the original post you said that you could use GROUP BY on all fields to get desired result. So which statement is correct?

>Does it? I mean, if there is a field Orders.Partno, and there are records for one OrdNbr that have different PartNos, won't those still come out as distinct records?
>
>Jim
>
>>If you don't have memo fileds in the table, following should work

>>SELECT DIST * FROM (
>>  SELECT Orders.*, tot.TOTAMT ;
>>    FROM Orders ;
>>      JOIN (SELECT OrdNbr, SUM(AMT) AS TOTAMT FROM Orders GROUP BY OrdNbr) tot ;
>>    ON tot.OrdNbr = Orders.OrdNbr
>>) dt1
>>