>Hi Naomi,
>
>My problem was that my LEFT JOIN was missing a simple expression like Field = uVaraible, which Tamar noticed and correctly suggested. My WHERE condition has a subquery similar to what you wrote in this reply. First I thought that I needed to move the subquery to the LEFT JOIN but it is not necessary. I am going to test the changes again today to be sure I am not missing something.
>
>You are correct, we did discuss this issue some months ago. And I thought I had a solution back then. But a few days ago, when a certain set of data came across, I found a problem with the logic. Adding SUBQUERY to the WHERE clause, so far, seems to resolve the issue.
>
>I don't know what to be impressed more: with your intuition to see in the past or with Tamar's such a sharp eye that she noticed something in seconds whereas I struggled with the problem for hours yesterday. I am glad I always find myself in a group of smart women :).
>
>Thank you.
>
:)
If it's not broken, fix it until it is.
My Blog