Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- command.CommandText = "SELECT Games.datePlayed, Games.nbrOfPlayers, Players.playerName " +
- "FROM (Games INNER JOIN (SELECT * FROM Results ORDER BY Results.points DESC) Results " +
- "ON (Games.gameNbr = Results.gameNbr)) " +
- "INNER JOIN Players ON (Results.playerNbr = Players.playerNbr) " +
- "GROUP BY Games.datePlayed, Games.nbrOfPlayers, Players.playerName;";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement