Re: Simple Query?

--- Koen Bok <koen@madebysofa.com> wrote:
> I am doing some optimization on our search, but I need some advise...
> 
> table: item
> 
> id            name
> --------------------------------------
> 1            iPod
> 2            Zune
> 3            Walkman
> 
> table: search_item
> 
> id_search    id_item
> --------------------------------------
> 1            1
> 1            2
> 1            3
> 2            2
> 2            3
> 3            1
> 3            3
> 
> 
> Now what I want to have is the items that match with id_search 1 and  
> 2 and 3. Therefore I use the following SQL query.

 SELECT id_search   FROM Search_item
GROUP BY id_search HAVING Count( * ) = 3    AND Max( id_item ) = 3    AND Min( id_item ) = 1;

Regards,
Richard Broersma Jr.