[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Bug-gnubg] One thing you can do with the sql db
From: |
Øystein Johansen |
Subject: |
Re: [Bug-gnubg] One thing you can do with the sql db |
Date: |
Thu, 06 Apr 2006 13:12:49 +0200 |
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