Re:SQLite now allows multiple recursive SELECT statements in...
by sradman on Wednesday October 21, 2020 @07:32AM
(#24846738)
Another good writeup is included in the SQL Anywhere documentation [1] which has a good example of a parts explosion problem [2]. I don't know if the syntax works in SQLite but it might be a good exercise to get it to work.
[1] http://dcx.sap.com/1200/en/dbusage/ug-commontblexpr.html
[2] http://dcx.sap.com/1200/en/dbusage/parts-explosion-cte-sqlug...