-- WHAT ALBUMS THE LED ZEPPELIN HAVE?
SELECT 
  r.Name AS ArtistName,
  r.artistid AS ArtistIDfromArtists,
  l.Title AS AlbumTitle,
  l.ArtistId AS ArtistIDfromAlbums
FROM artists_test AS r  --LEFT TABLE
LEFT JOIN _albums AS l --RIGHT TABLE
	ON r.ArtistId = l.ArtistId
-- WHERE AlbumTitle is NULL