Alright, I'm pinned in one of those situations where the legacy database is not designed as I would've done it, yet I still have to get the desired data out.
I have a "jobs" table, "locations" table, and "departments" table. There is a 1:1 of jobs to locations (job can only be in one location)...