| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Neil Tompkins | Date: | November 22 2012 2:30pm |
| Subject: | Basic SELECT help | ||
| View as plain text | |||
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
| Thread | ||
|---|---|---|
| • Basic SELECT help | Neil Tompkins | 22 Nov |
| • Re: Basic SELECT help | Mike OK | 22 Nov |
| • Re: Basic SELECT help | marek gutowski | 22 Nov |
| • Re: Basic SELECT help | Neil Tompkins | 22 Nov |
| • Re: Basic SELECT help | Benaya Paul | 22 Nov |
| • Re: Basic SELECT help | Neil Tompkins | 22 Nov |
| • RE: Basic SELECT help | Jason Trebilcock | 22 Nov |
| • Re: Basic SELECT help | Michael Dykman | 22 Nov |
| • Re: Basic SELECT help | Neil Tompkins | 22 Nov |
| • Re: Basic SELECT help | Michael Dykman | 22 Nov |
| • Re: Basic SELECT help | Neil Tompkins | 22 Nov |
| • Re: Basic SELECT help | Neil Tompkins | 22 Nov |
| • Re: Basic SELECT help | Neil Tompkins | 22 Nov |
| • Re: Basic SELECT help | hsv | 22 Nov |
| • Re: Basic SELECT help | Mogens Melander | 22 Nov |
| • Re: Basic SELECT help | Mogens Melander | 22 Nov |
| • Re: Basic SELECT help | Michael Dykman | 22 Nov |
| • Re: Basic SELECT help | hsv | 23 Nov |
| • Re: Basic SELECT help | Shawn Green | 19 Dec |
