On 10 Dec 2011, at 10:35pm, Nick Smallbone wrote: > the difference between my query and your query is > that I have a subquery (select * from b) and you don't.
I understand that SQLite handles VIEWs as if you had defined and saved a SELECT statement. So if you JOIN with a VIEW, does SQLite handle it as as JOIN or a sub-SELECT ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
