On 9/11/07, Koen Bok <koen@madebysofa.com> wrote:
> Anyone has a hint?
Another way:
SELECT i.* FROM item i JOIN search_item s1 ON i.ID = s1.id_item JOIN search_item s2 ON s1.id_item = s2.id_item
JOIN search_item s3 ON s2.id_item = s3.id_itemWHERE s1.id_search = 1 AND s2.id_search = 2 AND s3.id_search = 3