response did not go to the list..
I assume that you mean the id must be associated with both type=5 AND
type=2 as opposed to type=5 OR type=2;
in some dialect of SQL (not mysql) you can do this:
select distinct id from 'table' where type=5
intersect
select distinct id from 'table' where type=2
As INTERSECT is not avilable under mysql, we will have to go the JOIN route
select distinct a.id from mytable a
inner join mytable b on (a.id=b.id)
where a.type= 2 and b.type = 5;
- michael dykman
On Thu, Nov 22, 2012 at 9:30 AM, 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
--
- michael dykman
- mdykman@stripped
May the Source be with you.
--
- michael dykman
- mdykman@stripped
May the Source be with you.
