>Naomi this thread is three years old ???
I know, but I wanted to give not only you, but everyone the important link of how to solve the problem in general and also let you know about the danger of NULLs with IN subquery, especially since recently we had a similar problem.
If it's not broken, fix it until it is.
My Blog