I have a SELECT SQL statement like this:

SELECT Table1.codclie, Table1.Date Table2.Name FROM Table1, Table2;
WHERE Table1.codclie = Table2.codclie ORDER BY Table1.zone, Table1.codclie;
INTO CURSOR MyCursor

Table1.codclie Caracter 7
Table2.codclie Caracter 7

And I use the result cursor to print a report. The problem is that the SELECT, sometimes gets, for example, 10 records. And later if i intend to print the report again, the SELECT gets 11 records.
I mean, there is one o more record missing that should be selected.

Does anybody know what the SELECT statement takes on count at the moment of the selection?

Does the indexes have something to do with this???

Please, help me. This seems like a Nightmare to me.