List:General Discussion« Previous MessageNext Message »
From:Neil Tompkins Date:November 22 2012 2:45pm
Subject:Re: Basic SELECT help
View as plain text  
Basically I only what to return the IDs that have both types.


On Thu, Nov 22, 2012 at 2:39 PM, marek gutowski <marek.gutowski@stripped>wrote:

> SELECT DISTINCT id FROM table WHERE type IN ('2','5')
>
> should work
>
>
> On 22 November 2012 14:30, Neil Tompkins <neil.tompkins@stripped>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
>>
>
>

Thread
Basic SELECT helpNeil Tompkins22 Nov
  • Re: Basic SELECT helpMike OK22 Nov
  • Re: Basic SELECT helpmarek gutowski22 Nov
    • Re: Basic SELECT helpNeil Tompkins22 Nov
      • Re: Basic SELECT helpBenaya Paul22 Nov
        • Re: Basic SELECT helpNeil Tompkins22 Nov
  • RE: Basic SELECT helpJason Trebilcock22 Nov
    • Re: Basic SELECT helpMichael Dykman22 Nov
      • Re: Basic SELECT helpNeil Tompkins22 Nov
        • Re: Basic SELECT helpMichael Dykman22 Nov
      • Re: Basic SELECT helpNeil Tompkins22 Nov
      • Re: Basic SELECT helpNeil Tompkins22 Nov
      • Re: Basic SELECT helpNeil Tompkins22 Nov
  • Re: Basic SELECT helphsv22 Nov
Re: Basic SELECT helpMogens Melander22 Nov
Re: Basic SELECT helpMogens Melander22 Nov
  • Re: Basic SELECT helpMichael Dykman22 Nov
Re: Basic SELECT helphsv23 Nov
  • Re: Basic SELECT helpShawn Green19 Dec