(SELECT Egn FROM Sl_Bel WHERE Sl_Bel.God == 2005)return a big list, then you have to change the plan.
* try, but i'm not sure that force is used, AND THEN IT CAN TO BE SLOWER SELECT Rab.Egn,; Rab.Ime AS Ime,; 2005 AS God; FROM FORCE Sl_Bel ; RIGHT JOIN Rab ON Sl_Bel.God == 2005 AND Sl_Bel.Egn=Rab.Egn; WHERE Sl_Bel.Egn IN NULL; INTO CURSOR GodBel READWRITE NOFILTERWAY 2 ( vfp9 )
SELECT Rab.Egn,; Rab.Ime AS Ime,; 2005 AS God; FROM FORCE (SELECT DISTINCT Egn FROM Sl_Bel WHERE Sl_Bel.God == 2005) Sl_Bel1 ; RIGHT JOIN Rab ON Sl_Bel1.Egn=Rab.Egn; WHERE Sl_Bel1.Egn IN NULL; INTO CURSOR GodBel READWRITE NOFILTERhowever, the result depends on the COUNT(Sl_Bel1)/COUNT(rab) value,