• Try out this.

    Select '2' 'orderfield', field1, Field2 from table1

    union

    Select '1' 'orderfield', field3, Field4 from table2

    order by orderfield, <field> you want to order by

    You could think of re-writing your query on these lines by introducing dummy order by fields that would contain constants. It is not possible to order sub result sets in a Union.