It is using the country table and aliasing it to languages ... > -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of John Drescher > Sent: Tuesday, 24 September, 2013 10:50 > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Bug in sqlite3.exe? > > On Tue, Sep 24, 2013 at 12:35 PM, Staffan Tylen > <staffan.ty...@gmail.com>wrote: > > > SQLite version 3.7.16.2 2013-04-12 11:52:43 > > Enter ".help" for instructions > > Enter SQL statements terminated with a ";" > > sqlite> .tables > > City Country Languages > > Country Country Official Languages > > Country Capitals CountryLanguage > > sqlite> select count(*) from country languages; > > count(*) > > ---------- > > 239 > > > > Although I am a bit surprised that this query succeeded since there is > no > languages table. > > John > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users