On Thu, November 22, 2012 15:45, Neil Tompkins wrote:
> Basically I only what to return the IDs that have both types.
>
And that's exactly what below statement will return.
You forgot to include what platform you are on,
which version of MySQL you are running and
what class you are attending.
All necessary information to provide a sufficient help.
>
> On Thu, Nov 22, 2012 at 2:39 PM, marek gutowski
> <marek.gutow...@gmail.com>wrote:
>
>> 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
>>>
>>
>>
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
>
--
Mogens Melander
+66 8701 33224
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
