From: Neil Tompkins
Date: November 22 2012 2:45pm
Subject: Re: Basic SELECT help
List-Archive: http://lists.mysql.com/mysql/228684
Message-Id: <CADa_cYqTT7mVWx=aknGRUmP9p4Ms6sUYD8ku5mceKM9d3E+t2w@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=047d7b3a7fec6dc18204cf16859a

--047d7b3a7fec6dc18204cf16859a
Content-Type: text/plain; charset=ISO-8859-1

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

--047d7b3a7fec6dc18204cf16859a--