On Tue, Sep 24, 2013 at 12:53 PM, Staffan Tylen <staffan.ty...@gmail.com>wrote:
> Well, it's not my database I'm looking at. What puzzles me is that Country > Languages works but Country Official Languages doesn't, so could there be a > parsing problem? > > I think I see what is happening.. when you have a space in the from the second name is being taken as an AS (used for an alias) So in your You are counting the number of countries in your Country table. The following should work in that example: select count(languages.*) from country languages; John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
