... Special handling of CROSS JOIN. There is no difference between the "INNER JOIN", "JOIN" and "," join operators. They are completely interchangeable in SQLite. The "CROSS JOIN" join operator produces the same result as the "INNER JOIN", "JOIN" and "," operators, but ... 

7.1.2. Manual Control of Query Plans using CROSS JOIN Programmers can force SQLite to use a particular loop nesting order for a join by using the CROSS JOIN operator instead of just JOIN, INNER JOIN, NATURAL JOIN, or a "," join. Though CROSS JOINs are commutative in theory, SQLite chooses ... 

 ... expr factored-select-stmt filter-clause foreign-key-clause frame-spec function-arguments indexed-column insert-stmt join-clause join-constraint join-operator literal-value numeric-literal ordering-term over-clause pragma-stmt pragma-value qualified-table-name raise-function ... 

 ... The target table is not included in the FROM clause, unless the intent is to do a self-join against the target table. In the event of a self-join, the table in the FROM clause must be aliased to ... 

SQLITE_STMTSTATUS_FULLSCAN_STEP, SQLITE_STMTSTATUS_SORT, SQLITE_STMTSTATUS_AUTOINDEX, SQLITE_STMTSTATUS_VM_STEP, SQLITE_STMTSTATUS_REPREPARE, SQLITE_STMTSTATUS_RUN ... 

 ... SQLITE_STMTSTATUS_AUTOINDEX This is the number of rows inserted into transient indices that were created automatically in order to help joins run faster. A non-zero value in this counter may indicate an opportunity to improvement performance by adding permanent indices ... 

 ... ACID transactions using BEGIN, COMMIT, and ROLLBACK Nested transactions using SAVEPOINT, RELEASE, and ROLLBACK TO Subqueries, including correlated subqueries Up to 64-way joins LEFT, RIGHT, and FULL OUTER JOINs DISTINCT, ORDER BY, GROUP BY, HAVING, LIMIT, and OFFSET UNION ... 

5.2. Fixing The Problem  ... For this reason, the query was modified to use the CROSS JOIN operator instead of the plain JOIN operator. SQLite will not reorder the tables of a CROSS JOIN. This is a long-standing feature of SQLite that is specifically ... 

 ... Used by:   select-core   select-stmt   table-or-subquery   update-stmt   update-stmt-limited References:   join-constraint   join-operator   table-or-subquery See also ... 

14. SQLite Gets The Precedence Of Comma-Joins Wrong SQLite gives all join operators equal precedence and processes them from left to right. But this is not quite correct. It should be that comma-joins have lower precedence than all others join operators. In other words, a FROM clause ... 

3.4. Update multiple columns of a table based on a query  ... But the three columns "label", "url", and "mtime" all require a join query against the "event" and "blob" tables. Without row values, the equivalent UPDATE would require that the join be repeated three times, once for each column to be ...