I agree that correlated subqueries in general seem more natural and are probably also less likely to have the performance pessimizations noticed with joins.
But I might also want to use the column, or in case of a correlated subquery, the column alias, in the WHERE clause and previously that has not been supported as I recall. Maybe also not allowed by SQL specification itself? I modified the suggested query and used the column alias in WHERE now though, and it seemed to work! Is this a recent change in Sqlite or have I misunderstood something? The Sqlite documentation still does not seem to say that column aliases can be used in the WHERE clause at least. -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
