SELECT AVG(snowie_error_rate_per_move)*1000 from matchstat INNER JOIN nick on matchstat.nick_id = nick.nick_id where nick.name = 'user';
Thanks! I have to look further on this database feature. About the above selection: Isn't better to use a natural join? SELECT AVG(snowie_error_rate_per_move)*1000 from matchstat NATURAL JOIN nick where nick.name = 'user'; ?? -Øystein _______________________________________________ Bug-gnubg mailing list [email protected] http://lists.gnu.org/mailman/listinfo/bug-gnubg
