A performance penalty for first selecting the records and then reporting (twice) only the records you want vs. reporting all records and weeding out those that you didn't want in the process (twice). I don't think so.
Besides the way you're doing it now isn't working so what are you losing?
>That makes sense; thanks! Think there would be any significant performance penalty (the tables involved have 200,000+ records)?
-cjh