In UltraLite, you can only use subquery references in the following situations:
As a table expression in the FROM clause. This form of table expression (also called derived tables) must have a derived table name and column names in which values in the SELECT list are fetched.
To supply values for the EXISTS, ANY, ALL, and IN search conditions.
You can write subqueries about names that are specified before (to the left of) the subquery, sometimes known as outer references
to the left. However, you cannot have references to items within subqueries (sometimes known as inner references).