SELECT DISTINCT id FROM table WHERE type IN ('2','5') should work
On 22 November 2012 14:30, Neil Tompkins <neil.tompk...@googlemail.com>wrote: > Hi, > > I'm struggling with what I think is a basic select but can't think how to > do it : My data is > > id,type > > 1000,5 > 1001,5 > 1002,2 > 1001,2 > 1003,2 > 1005,2 > 1006,1 > > From this I what to get a distinct list of id where the type equals 2 and 5 > > Any ideas ? > > Neil >