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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users