FIX: SQL SELECT Returns Different Results Using the Same Data

MORE INFORMATION

Steps to Reproduce Problem

   SET SAFETY OFF
   CLOSE ALL

   CREATE TABLE main (num N(1), link C(50), crit C(50))
   INSERT INTO main VALUES (1, "YES", "YES")
   INSERT INTO main VALUES (2, "NO", "YES")
   INSERT INTO main VALUES (3, "NO", "NO")
   INSERT INTO main VALUES (4, "YES", "NO")

   CREATE TABLE link (link C(50))
   INSERT INTO link VALUES ("YES")

   CLOSE ALL
   CLEAR

   FOR i = 1 TO 2

      lcTmpFile = "tmp" + ALLTRIM(STR(i)) + ".dbf"
      IF FILE(lcTmpFile)
         ERASE (lcTmpFile)
      ENDIF

      SELECT num, link, crit FROM main ;
         WHERE ((main.link IN (SELECT link.link FROM link)) OR ;
            (crit = "YES")) INTO TABLE (lcTmpFile)

      ? _TALLY

   ENDFOR