- --Task 11
- Find all items and information whether and what forbidden game types they have. Display item name, price, min level and forbidden game type. Display all items. Sort the results by game type in descending order, then by item name in ascending order.
- i.Name as Item,
- gt.Name as [Forbidden Game Type]
- from Items i
- left join GameTypeForbiddenItems gtfi
- on i.Id = gtfi.ItemId
- left join GameTypes gt
- on gtfi.GameTypeId = gt.Id
- order by [Forbidden Game Type] desc, i.Name asc
a guest Jul 14th, 2015 172 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
RAW Paste Data