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 sqlite> select count(*) from country official languages; Error: near "languages": syntax error sqlite> select count(*) from country official; count(*) ---------- 239 sqlite> select count(*) from countrylanguage; count(*) ---------- 988 sqlite> select count(*) from languages; Error: no such table: languages sqlite>
I'm aware the version of SQLite is not current so it might already have been fixed. Staffan _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
