apap
07-02-03, 09:16
| 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. |