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. _______________________________________________ Bug-gnubg mailing list [email protected] http://lists.gnu.org/mailman/listinfo/bug-gnubg
