Advertisement
Guest User

Untitled

a guest
Jul 27th, 2017
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. command.CommandText = "SELECT Games.datePlayed, Games.nbrOfPlayers, Players.playerName " +
  2. "FROM (Games INNER JOIN (SELECT * FROM Results ORDER BY Results.points DESC) Results " +
  3. "ON (Games.gameNbr = Results.gameNbr)) " +
  4. "INNER JOIN Players ON (Results.playerNbr = Players.playerNbr) " +
  5. "GROUP BY Games.datePlayed, Games.nbrOfPlayers, Players.playerName;";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement