Advertisement
Guest User

Problem 23. All User in Games

a guest
Feb 9th, 2017
223
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.37 KB | None | 0 0
  1. SELECT g.Name AS 'Game', gt.Name AS 'Game Type', u.Username, ug.Level, ug.Cash, c.Name AS 'Character'
  2. FROM UsersGames AS ug
  3. INNER JOIN Games AS g
  4. ON ug.GameId = g.Id
  5. INNER JOIN GameTypes AS gt
  6. ON g.GameTypeId = gt.Id
  7. INNER JOIN Users AS u
  8. ON ug.UserId = u.Id
  9. INNER JOIN Characters AS c
  10. ON ug.CharacterId =  c.Id
  11. ORDER BY ug.Level DESC, u.Username ASC, gt.Name ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement