General information
Title:
Using the union all in select query can u please can u check
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************************
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