>Hi Sergey,
>
>They were the same in both tables. I and my manager don't see an explanation besides index corruption, so we would reindex this database (by packing each table) at the end of the day.

Nadya,

You can find out if this is index related by simply;

SET OPTIMIZE OFF

and then running your SELECT to see if the data you get is corrected. If it is correct then the problem is indexes otherwise it is not indexes.