Hi, A.,

Something like this?...

SELECT s1.codeno ;
   FROM sample s1, sample s2 ;
   WHERE s1.certno=10 AND s2.certno=15 AND s1.codeno=s2.codeno

>when the IN clause is specified it selects data even if it has satisfied only ONE of the conditions in the IN clause. What i am trying to achieve is that it should select a record only if ALL conditions are met, that is, only if condition A AND condition B AND .... are satisfied should the data be selected.

bye