If you have to have these temp tables, as opposed to using Jamie's suggestion (which I believe is optimal), then you should have some unique identifier for users right? For each temp table you have opened, use regular inner joins to join them together where temptable1.userid = temptable2.userid etc etc and you should wind up with only users that meet all specified criteria.

>I have a routine which determines which users get email. In a table for this email it looks as the groups to email to. It then opens a table for each group defined with the users in it. For example I want to email users who are located in london and are in the department design. So my routine creates 2 temp tables with all the users in london in one table and in the other all the users in Design. All I need to do now is email users who satisfy both groups (conditions). How can I do this easily. Bare in mind I may have more than 2 conditions. For each condition I will open a new temp table.
>
>Any ideas?