Advertisement
StoyanGrigorov

27. Display All Items about Forbidden Game Type

Feb 7th, 2017
198
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.26 KB | None | 0 0
  1. SELECT it.Name AS [Item], it.Price, it.MinLevel AS [MinLevel], gt.Name AS [Forbidden Game Type]
  2. FROM Items AS it
  3. INNER JOIN GameTypeForbiddenItems AS gtfi
  4. ON gtfi.ItemId = it.Id
  5. INNER JOIN GameTypes AS gt
  6. ON gt.Id = gtfi.GameTypeId
  7. ORDER BY gt.Name DESC, it.Name
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement