Simon Slavin wrote: > On 26 Nov 2017, at 8:02am, Shane Dev <[email protected]> wrote: >> Any ideas to achieve this? > > Use the UNION keyword to combine the results of the two SELECT commands
That would not order the close tags correctly. >> Any ideas to achieve this? Would it be possible to have parentid fields? <http://www.sqlite.org/lang_with.html#withorderby> Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
