SELECT Artist.Name, Album.Name, Track.Name
FROM dbo.Artist
INNER JOIN dbo.Album
ON Artist.ArtistID = Album.ArtistID
INNER JOIN dbo.Track
ON Track.AlbumID = Album.AlbumID
ORDER BY TrackID desc