Thanks for your reply ... it's giving me the opposite of what I want because I phrased my question badly.

I have modified my temporary table in my first post to include a TemplateID

Join to the temporary table but only if every group within the temporary table has a BaseStage of 1.

i.e. make it so that if there is a group without a BaseStage of 1 - it returns nothing - no join happens.