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

Reply via email to