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.
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.