> Try it this way instead and report back:
>
> SELECT t1.id FROM table1 t1
> WHERE
> t1.id IN (SELECT A.ID FROM table1 A
> JOIN table1 B ON B.ID = A.ID
> WHERE B.ID IN('1', '2', '3'))
> AND
> NOT t1.id IN (SELECT A1.ID FROM table1 A1
> JOIN table1 B1 ON B1.ID = A1.ID
> WHERE B1.ID IN('2', '3'))
>
> ./helen