sqlite> select * from albums left join artists on albums.artist_id = artists.id; 
1       A Hard Days Night       1       1964    1       The Beatles
2       Elvis Presley   2       1956    2       Elvis Presley
3       1989            2014            
4       Yellow Submarine        1       1968    1       The Beatles
5       Hey Jude        1       1970    1       The Beatles
6       Like a Virgin   4       1984    4       Madonna
7       From Elvis in Memphis   2       1969    2       Elvis Presley
8       Bad     3       1987    3       Michael Jackson
9       Elton John      5       1970    5       Elton John
10      Like a Prayer   4       1989    4       Madonna
11      The Dark Side of the Moon       7       1973    7       Pink Floyd
12      Thriller        3       1982    3       Michael Jackson
13      Unorthodox Jukebox              2012            
14      The Wall        7       1979    7       Pink Floyd