SQLite Forum

Join Question
Login
select s.main,a.name,s.backup,b.name
from support s, names a, names b
where s.main=a.key
and s.backup=b.key;

Main  Name    Backup  Name
----  ------  ------  -----
10    Bob     72      Sally
106   Amanda  73      Jose

Edit: This is essentially the same solution at the previous post. Apologies.