sorting a union query

[karerda]

Hallo,
i have a very simple union query that populate a combobox. I would like it to be in alphateical order but srangeli it doesnt' work.

SELECT tbl_Country.Cou_ID, tbl_Country.Cou_Name FROM tbl_Country ORDER BY tbl_Country.Cou_Name UNION SELECT "*", "<All>" FROM tbl_Country;

I don't why but if I leave out the union statement it will display correctly:

SELECT tbl_Country.Cou_ID, tbl_Country.Cou_Name FROM tbl_Country ORDER BY tbl_Country.Cou_Name;

any ideas?

 

[bjackson]

i think you need to move your order by
SELECT tbl_Country.Cou_ID, tbl_Country.Cou_Name FROM tbl_Country
UNION SELECT "*", "<All>" FROM tbl_Country
ORDER BY tbl_Country.Cou_Name

 

[karerda]

thanks bjackson, this works