Thank you. That worked.
On Thu, Oct 24, 2013 at 5:00 PM, Igor Tandetnik <i...@tandetnik.org> wrote: > On 10/24/2013 7:34 PM, Igor Korot wrote: > >> So I was thinking of something like this: >> >> UPDATE leagueplayers SET original_rank = (SELECT rank FROM players AS a), >> current_rank= a WHERE players.playerid = leagueplayers.playerid; >> >> But I guess this query will not work. ;-) >> >> Any idea how to make the proper query? >> > > I can't think of anything better than > > UPDATE leagueplayers SET > original_rank = (SELECT rank FROM players WHERE players.playerid = > leagueplayers.playerid), > current_rank = (SELECT rank FROM players WHERE players.playerid = > leagueplayers.playerid); > > Or two statements: > > UPDATE leagueplayers SET > original_rank = (SELECT rank FROM players WHERE players.playerid = > leagueplayers.playerid); > UPDATE leagueplayers SET current_rank = original_rank; > > > -- > Igor Tandetnik > > ______________________________**_________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users