Simon Slavin wrote: > On 26 Nov 2017, at 8:02am, Shane Dev <devshan...@gmail.com> 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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users