You can make similar second select for ocrtable1 table and join them both with UNION ALL.
BTW, it's better to use 2-3 letter meaningfull aliases in the queries. It makes code easier to read and maintain.

>Please help i am counfused how to make the query to search both the tables ocrtable and ocrtable1 both are same type of table with same fields etc.
>
>since the ocrtable reached 2gb limit thats why we had to create another new table with the same name but one at the end.
>
>Now when i fire the following query it searches in ocrtable from now on i want to also include ocrtable1 in it and what ever the data comes need to be pushed into the cursor and then i will bind the cursors data into the datagrid.
>
>Please help if you don't mind.
>

>LcSQL = [select distinct(a.tiffile), b.proj_no, b.workpkg_no];
>+[from ocrtable a, docudeck b, docindex c ;
>WHERE UPPER(b.file_name) = UPPER(a.tiffile) ;
>and b.docindex_i = c.docindex_i ;
>and Upper(a.OCDATA) like "%] + Upper(alltrim(stxtocrstring)) + [%"] + swhere +;
>[ order by a.id into Cursor lcSource]
>

>
>The data in both the tables is unique the key field is ID which is completely unique in both the tables ocrtable and ocrtable1 no 2 records in both tables has a same id.