R Smith wrote: > you need to alias a subquery always when it is used in a join
Not in SQLite. > you need to explicitly limit a subquery that is a field and must only > ever return 1 result if the where clause is ambiguous about it Not in SQLite. (It ignores superfluous rows, and returns NULL if there are no rows.) Regards, Clemens