Advertisement
Guest User

Untitled

a guest
Apr 28th, 2017
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. SELECT
  2. Track.Name AS TrackName,
  3. Album.Title AS AlbumTitle,
  4. Artist.Name AS ArtistName,
  5. Track.UnitPrice AS UnitPrice
  6. FROM Track
  7. INNER JOIN Album
  8. ON Track.AlbumId = Album.AlbumId
  9. INNER JOIN Artist
  10. ON Album.ArtistId = Artist.ArtistId
  11. JOIN Genre
  12. ON Genre.GenreId = Track.GenreId
  13. WHERE Genre.SOMECOLUMN = ' + genre + ' ORDER BY Artist.Name;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement