[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: |
Christian Anthon |
Subject: |
Re: [Bug-gnubg] One thing you can do with the sql db |
Date: |
Thu, 6 Apr 2006 13:33:12 +0200 |
User-agent: |
Mutt/1.5.10i |
On Thu, Apr 06, 2006 at 01:12:49PM +0200, Øystein Johansen wrote:
> 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';
>
> ??
Sure seems so. ;)
Christian.