>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.

Ohoh, you are right I din't read well the question so I thoughed that the selField contains "english, french"...