SELECT
  *
FROM
  albums
LEFT JOIN artists ON
  albums.artist_id = artists.id;