Simon Slavin <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
