I have the following data in a table named dtlstbl which has columns id and refid
I am fetching data from this table thus
select id from dtlstbl where refid in (1,2)
All the records are returned.
I want a SQL 2000 query that will return only the following result
ie. id's which have ref id both 1 and 2.