that looks like it should do the trick, there are two things I can think of:
1) you have not included a repeat region around the recordset out put.
2) There is not a match in the in the users.UserID column for the other clients.ClientUserID records, try using a right join or a left join.