Hello Koen,

I just noticed this returns the same results.

Do I really need this last line ?

SELECT *

FROM prj_demo_data

WHERE prj_code IN

(

SELECT prj_code

FROM prj_demo_data

WHERE demo_code = 'DE1' and demo_data_vchar = 'U'

INTERSECT

SELECT prj_code

FROM prj_demo_data

WHERE demo_code = 'RAP' and demo_data_vchar = 'YES'

)

--code works even without this line?...

--AND demo_code IN ('DE1','RAP') AND demo_data_vchar IN ('U','YES')