>Thanks Sergey,
>
>that's the same solution Naomi provided which works (now I just need to adjust all the rest of my code to fit in an INNER JOIN nistead of a WHERE).
>
It is different solution (uses sub-queries).
If it's not broken, fix it until it is.
My Blog