use ORDER BY CboValuesTranslations.cboValueTranslationName Asc

for 1st Select statement and then use union with 2nd select statement.

or

Write a Select on top of Statements and then sort...