数据表如下
player:
playerId | combat |
---|---|
1 | 4 |
2 | 16 |
3 | 2 |
4 | 7 |
guild:
guildId | chairmanId |
---|---|
11 | 1 |
12 | 2 |
13 | 3 |
14 | 4 |
MySQL语句如下
SELECT g.* ,p.combat FROM guild g, player p WHERE g.chairmanId = p.playerId ORDER BY p.combat DESC;
查询结果如下
guildId | chairmanId | combat |
---|---|---|
12 | 2 | 16 |
14 | 4 | 7 |
11 | 1 | 4 |
13 | 3 | 2 |
网友评论