Artur Reilin <[email protected]> wrote: > CREATE TABLE [challenge_players] > ( > [player_id] INTEGER PRIMARY KEY , > [player_name] TEXT > ) > > CREATE TABLE [challenge_wins] > ( > [round_id] INTEGER PRIMARY KEY , > [round_winner] INTEGER > ) > > I tried to do a joined select to get the both tables together. I want to > sort them after how much wins a player has.
select player_id, player_name, count(round_winner) player_wins from challenge_players left join challenge_wins on (player_id = round_winner) group by player_id order by player_wins desc; -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
