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 wor

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 http://dcx.sap.com/1200/en/dbusage/ug-commontblexpr.html [2] http://dcx.sap.com/1200/en/dbusage/parts-explosion-cte-sqlug.html http://dcx.sap.com/1200/en/dbusage/parts-explosion-cte-sqlug...