selecting across multiple tables to check permission
Posted on 2008-11-01
I have a series of tables
and then i have users
and then finally which districts the users can view
I want to get a list of all people but only people that belong to offices which are in districts that I as a user can see. A user may see multiple districts.