My first thought (untested) SELECT Support.Key as Support_Key, Main.name as Main_Name, Back.name as Back_Name FROM Support JOIN Names as Main on Support.Main = Main.Key JOIN Names as Back on Support.Backup = Back.Key Since you are pulling from Names twice, you need to give it aliases to refer to the two copies.