-- Künstler und ihr Album
SELECT artists.Name, albums.Title
FROM artists
INNER JOIN albums
ON (artists.ArtistId = albums.ArtistId);