>Hi
>
>I have 7 offices that all use my VFP6.0 application.
>
>On one of the views, it is doing a UNION Select statement and then ordering at the end on 2, 4.
>
>The only problem is that on one of the offices fields 2 and 4 are different because of their position in the table.
>
>I understand that the short-term solution is to change the view so that it orders correctly to that particular office, but I would rather know a way of avoiding this issue completely?
>
>Anyone?
>Cheers
>Kev

---

How does your select looks like then?
If you have TableA
ID,sort1,test,sort2

and TableB
ID,sort2,sort1,test

you can select that by:
select id,sort1,test,sort2 from tableA;
union;
select id,sort1,test,sort2 from tableB;
order by sort1,sort2;
into IDontKnowWhatCursor

you don't have any problem in ordering?