Advertisement
Guest User

Untitled

a guest
Oct 8th, 2019
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.33 KB | None | 0 0
  1. SELECT g.[Name],i.[Name] AS [Item Name],i.MinLevel,it.[Name] AS [Item Type]
  2. FROM Games AS g
  3. JOIN GameTypes AS gt ON g.GameTypeId = gt.Id
  4. JOIN GameTypeForbiddenItems AS gtfi ON gtfi.GameTypeId = gt.Id
  5. JOIN Items AS i ON i.Id = gtfi.ItemId
  6. JOIN ItemTypes AS it ON it.Id = i.ItemTypeId
  7. WHERE g.[Name] = 'Safflower'
  8. ORDER BY g.[Name]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement