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
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