Another way: sqlite> .mode column sqlite> .headers on sqlite> SELECT a.KEY, ...> a.MAIN, ...> a.BACKUP, ...> b.NAME ...> FROM SUPPORT a ...> INNER JOIN NAMES b ON a.BACKUP = b.KEY; Key Main Backup Name --- ---- ------ ----- A 10 72 Sally B 106 73 Jose sqlite>