Boris,

Here's how to get the ruslt you want;

SELECT Name ;
  FROM People ;
 WHERE SelField = "English" ;
   AND Name IN (SELECT Name ; 
                  FROM People ;
                 WHERE SelField = "French") ;
 INTO CURSOR MyResult

The other suggestions will fail beacuse there is no record where selfield is "English" and "French" both.