>Thanks Sergey,
>
>So, it's like the crsPMPlanH record pointer stays on the current record for the WHERE, but moves through the table for the JOIN. Is that it put simply or is there more to it than that?
>
Hi Renoir,
The pointer didn't move with WHERE because you didn't include second table into FROM clause. If you did, the result of both queries would be the same.
--sb--