SQLite Forum

Recursive CTE
Login
SQL where every row in the LEFT table inherits every row in the RIGHT table i.e. Cartesion or CROSS JOIN makes for very poor runtime performance.

My example had just one row in "tmp", for making my point (workable in the CLI). In practice, it will have multiple rows. Since SQLite does not have explicit loops, the iteration will need to be in the application.