>>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.

I've ran it and still got incorrect results... Very strange... May be our Customer table was somehow changed and now doesn't correspond to that it should be. But in this case we would find this sooner...

Even more strange: we have a JobViewer form which allows to see Customer Info on the Job Details page. I looked at these jobs and see incorrect info. However, then I edit the job (e.g. bring the Selection criteria screen, then Customer info screen), the customer is correct and then it's correctly shown in the form. E.g. it starts incorrect, but if I hit Edit button and follow through the steps, it finally gets corrected. What may cause this really weird problem?

UPDATE. Ok, I found the problem. Our Jobs table doesn't have correct CustomerID, while Delivery table does have them. So, we probably need to correct Jobs.CustomerID field, though one job can have multiple deliveries to different customers.