SELECT Name ; FROM People ; WHERE SelField = "English" ; AND Name IN (SELECT Name ; FROM People ; WHERE SelField = "French") ; INTO CURSOR MyResultThe other suggestions will fail beacuse there is no record where selfield is "English" and "French" both.