Re: JOIN from 3 tables - not possible to do it with subquerys

[Felix Geerinckx]

Tobias Kazmierczak Wrote:

> it there a way for a query in mysql 4 or do i have
> to update also the server

Does

SELECT 
    i.id,
    SUM(ik.relevance) AS SR
FROM images i
JOIN imgkey ik ON ik.id_img = i.id
JOIN keywords k ON k.id = ik.id_key
WHERE 
    k.keyword_en IN  ("Jesus", "Mary")
GROUP BY i.id
HAVING COUNT(i.id) = 2   -- 2 = number of elements in IN-list
ORDER BY SR DESC;

work?

--
felix
Please use BBCode to format your messages in this forum.