Hi Steven,
>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
>
Because of the Group By clause. There are two different Group By clause. First is "Group By cono" and second is "Group By cono, archivef" and it that can to return different count.
Erick
Força Sempre!
Strength Always!