1. HOW CAN I USE " ORDER BY " IN A VIEW IN PERVASIVE DB?

2. I HAVE AN OUTER JOIN AND I WANT TO USE "ORDER BY " IN THE SELECT CLAUSE BEFORE THE JOIN TAKES PLACE. MY PROBLEM IS THE FOLLOWING IF THE "ORDER BY " IS WRITTEN AT THE END OF THE STATEMENT LIKE IN THE SCREEN BELOW IT IS VERY SLOW

" Select XXX,
CCC,
VVV,
ad1.BBB as ADSType,
NNN,
MMM,
KKK,
LLL
ad2.OOOas ADCountry
from Address
left join UDCValue ad1 on (ad1.UDCVID = 1 and ad1.UDCVLineNo = ADSTypeLineNo )
left join UDCValue ad2 on (ad2.UDCVID = 7 and ad2.UDCVLineNo = ADCountryLineNo)
order by Adid "

HOW CAN I SORT MY DATA AND AFTER MAKE THE JOINS.