Simon Slavin <slav...@bigfraud.org> writes: > 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 ?
It's just the same as if you JOIN with a sub-SELECT (the query for the view), as far as I can tell. So if you LEFT JOIN with a VIEW you always get this problem. Nick _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
