SQLite Forum: Join Question

Another way

.mode column
.headers on

SELECT a.Main,
	c.Name AS Name,
	a.BACKUP,
	a.Name AS OtherName
FROM (
	SELECT *
	FROM SUPPORT a
	INNER JOIN NAMES b ON a.BACKUP = b.KEY
	) a
INNER JOIN NAMES c ON a.Main = c.KEY;

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