Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- Track.Name AS TrackName,
- Album.Title AS AlbumTitle,
- Artist.Name AS ArtistName,
- Track.UnitPrice AS UnitPrice
- FROM Track
- INNER JOIN Album
- ON Track.AlbumId = Album.AlbumId
- INNER JOIN Artist
- ON Album.ArtistId = Artist.ArtistId
- JOIN Genre
- ON Genre.GenreId = Track.GenreId
- WHERE Genre.SOMECOLUMN = ' + genre + ' ORDER BY Artist.Name;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement