SQLite Forum

Join Question
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.