Re: [Bug-gnubg] One thing you can do with the sql db

[Øystein Johansen]

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