Nested union query

[JAPA1972]

I have a union query attached to a combobox with a query field called LASTNAME. Unfortunately the records are not sorted by LASTNAME as the UNION query messes up with the order. How can I have all the records in the UNION query sorted by LASTNAME? Do I have to create a nested query? If so, how? Thanks.


SELECT FIRSTNAME, LASTNAME FROM TABLE1 ORDER BY LASTNAME UNION FIRSTNAME, LASTNAME FROM TABLE2 ORDER BY LASTNAME

[isladogs]

Just use order by after the final union