I am in an ongoing debate with my technical managers regarding accessing lookup tables and he keeps waving the "best practices" mantra at me but offers nothing concrete, I have several lookup tables ...

I need to return a query set that contains username, organizationname, and rolename for a given userid. Can someone give me a shove in the right direction? I've been out of full time dev for way too ...