Just looking at it briefly you can only have the ORDER BY clause on the last SELECT.

-mike

>I have the following query which is pointing to two selecxt statements both the select statements are same bcos, we had a 2 gb problem with the first table so i c reated a new table with 1 to the same name ocrdata.
>now i want to get the data and put into Cursor lcSource.
>
>Can you please tell me am i doing it right or not, Please help.
>Thank you.
>**************************Code**********************************
>LcSQL = [select distinct(a.tiffile), b.proj_no, c.docindex_i ];
>+[from ocrdata a, docudeck b, docindex c ;
>WHERE Upper(a.OCDATA) like "%] + Upper(alltrim(stxtocrstring)) + [%"] + swhere +;
>[ order by a.id Union All ];
>+[select distinct(a.tiffile), b.proj_no, c.docindex_i ];
>+[from ocrdata1 a, docudeck b, docindex c ;
>WHERE Upper(a.OCDATA) like "%] + Upper(alltrim(stxtocrstring)) + [%"] + swhere +;
>[ order by a.id into Cursor lcSource]
>
>********************************End************************