SQLite Forum

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