SQLite Forum

UNION Sorts on First Field
With UNION ALL it goes correct. But it can go haywire any-time?

I do not know of an ORDER BY clause that will give the correct sequence. ;-)  
But at the moment it works.  
When it does not any-more I could prepend '1 ', '2 ' and '3 ' to them.