Came across a small problem.
I have a master table that contains a record of each member. In this talbe there are two fields; "HomeState", and "WorkState". Both of these fields have a Int value representing the ID value of the corresponding state in the States table.
I'm trying to pull back the data as such:
Member, HomeState, WorkState
Joe.Smoe, TX, AZ
Jane.Doe, VA, DC
What sort of JOIN would one use to accomplish this? Is it even possible?