I have a query I want to optimize. But I get a strange (accoirding to me :o))) result. When I write the query that way:

SELECT Rab.Egn,;
       Rab.Ime AS Ime,;
       2005        AS God;
       FROM Rab;
WHERE Rab.Egn NOT IN (SELECT Egn FROM Sl_Bel WHERE Sl_Bel.God == 2005);
INTO CURSOR GodBel READWRITE NOFILTER

I get following result of SYS(3054)

---------------------------
Microsoft Visual FoxPro
---------------------------
Rushmore optimization level for table rab: none
Using index tag Sl_god to rushmore optimize table sl_bel
Rushmore optimization level for table sl_bel: full
Joining table rab and table sl_bel using index tag Sl_egn

But when I split the query:

SELECT Egn FROM Sl_Bel WHERE Sl_Bel.God == 2005 INTO ARRAY mmm

SELECT Rab.Egn,;
       Rab.Ime AS Ime,;
       2005        AS God;
       FROM Rab;
WHERE Rab.Egn NOT IN (mmm);
INTO CURSOR GodBel READWRITE NOFILTER

The result is:

---------------------------
Microsoft Visual FoxPro
---------------------------
Using index tag Rabi to rushmore optimize table rab
Rushmore optimization level for table rab: full

Why? Where is the difference?