>Hello Naomi,
>
>It does the same thing with yours as well. I have ran both several times and I get the same results ...
>
>Any idea what this could be?
>
>
>John
How exactly you need to get the only one record?
Can you post DDL of the tables and expected result?
If it's not broken, fix it until it is.
My Blog