SQLServerCentral / Database Design / Relational Theory / Possible Join of One Table Field to Two Master Table Fields? / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 26 May 2013 03:23:29 GMT20RE: Possible Join of One Table Field to Two Master Table Fields?http://www.sqlservercentral.com/Forums/Topic603750-374-1.aspxYou're a champion, Chris!Thank you very much! :DMon, 17 Nov 2008 09:46:47 GMTliam.bellRE: Possible Join of One Table Field to Two Master Table Fields?http://www.sqlservercentral.com/Forums/Topic603750-374-1.aspxLiam, you need to join the states table twice:[code]SELECT m.member, h.HomeState, m.WorkState FROM master mLEFT JOIN States h ON h.[ID] = m.HomeStateLEFT JOIN States w ON w.[ID] = m.WorkState[/code]CheersChrisMMon, 17 Nov 2008 09:36:26 GMTChrisM@WorkPossible Join of One Table Field to Two Master Table Fields?http://www.sqlservercentral.com/Forums/Topic603750-374-1.aspxCame 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, WorkStateJoe.Smoe, TX, AZJane.Doe, VA, DCWhat sort of JOIN would one use to accomplish this? Is it even possible?Cheers.Mon, 17 Nov 2008 09:32:18 GMTliam.bell