>SELECT DISTINCT f.id FROM Table1 AS t, Features AS f >WHERE f.id = t.id AND f.FeatureCode IN ('A01', 'B02');
>HTH what if i have a record that have 'A01' in the features, but not 'B02' wouldnt it still be displayed in the result? as far as i know, IN keyword act simply as OR keyword didnt Jonathan wrote : >But it I want all records from Table1 that have features 'A01' _and_ 'B02' notice the _and_ ? -leo-