>So If you wish to use order by with names you should have additional AS clauses with names different from your field names.
See, this is where the problem is. If you don't do any ORDER BY, look at the SQL result. All the field names are as is. So, there shouldn't be any reason why I should do SELECT myfield AS myfield,myfield2 AS myfield2. This doesn't make any sense. There is something wrong when using UNION.