>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.


Seems to me you need some join conditions in those queries, so you don't get cartesian joins.

Tamar