General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only