*-- create some test data CREATE CURSOR roleAll (id i) FOR i = 1 TO 1000 INSERT INTO roleAll VALUES(i) ENDFOR CREATE CURSOR roleGrant (id i) FOR i = 1 TO 1000 STEP 4 INSERT INTO roleGrant VALUES(i) ENDFOR &&* i = 1 TO 1000 *-- A) using a sub-query SELECT * FROM RoleAll WHERE id NOT IN(SELECT id FROM RoleGrant) *-- or B) using a LEFT JOIN SELECT RoleAll.*; FROM RoleAll; LEFT JOIN RoleGrant ON RoleAll.id = RoleGrant.id; WHERE ISNULL(RoleGrant.id)If I missunderstood your question, maybe you could post some more information.