yep, when I placed the active = 1 into the join, it returned the expected results - thanks for your help. Any simple explanation or online resources available that explain...