>Why would to two following SQL statements return different record counts?
>
>sqla = "SELECT Count(*) As rCount FROM webprddt6.tsotagtbl Where archivef = '0' Group By cono"
>
>sql = "SELECT cono, archivef FROM webprddt6.tsotagtbl Where archivef = '0' Group By cono, archivef"
>
>The first returns 128
>
>The second 133
>
You re grouping on 2 fields in the second query and on 1 in the first.
--sb--