SELECT 
  l.Title,
  r.Name,
  r.artistid
FROM _albums  AS l
INNER JOIN _artists AS r
	ON l.ArtistId = r.ArtistId;
    
    
    
 -- USING CLAUSE   
SELECT 
  l.Title,
  r.Name,
  r.artistid
FROM _albums  AS l
INNER JOIN _artists AS r
	USING(ArtistId)