>Roi,
>As Mark said, you could build an IN clause if the number of possible values are limited. Instead of a sub-query, you could achieve the same result with an INNER JOIN.
Thanks Daniel. There could be a very large number of items for the in. I had thought about the join but I think it's a little easier to read with Where In.
Roi
'MCP' Visual FoxPro
In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!