Hello.
So I tested yesterday some queries with joins and cannot found the right
solution. So I'm trying it here and hope you have a solution or an Idea. I
think it's some really easy thing and I just don't get it.
Okay let's see:
I have the following scheme:
CREATE TABLE [challenge_players]
(
[player_id] INTEGER PRIMARY KEY ,
[player_name] TEXT
)
CREATE TABLE [challenge_wins]
(
[round_id] INTEGER PRIMARY KEY ,
[round_winner] INTEGER
)
challenge_players just contain a list of all players.
challenge_wins is list of all rounds with the winner player_id as
round_winner.
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.
Something like:
player_id = 1; player_name = testuser; player_wins = 3;
I hope you have an idea for me.
with best regards
Artur Reilin
sqlite.yuedream.de
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
