ello,
I have this sql statement
SELECT title, mk.material_id
FROM materials m, materialsKeywords mk, keywords k
WHERE (m.material_id = mk.material_id) AND (k.keyword_id = mk.keyword_id) AND
word IN ('freedom', 'east timor')
GROUP BY title, mk.material_id
HAVING (COUNT(mk.material_id)) = 2
The above works well untill I have
word IN ('freedom', 'east timor') OR word IN ('australia')
how do I count for the material with the matching search words?
or should I use other join statements?
thanks for any tips or help!
annalise
I have this sql statement
SELECT title, mk.material_id
FROM materials m, materialsKeywords mk, keywords k
WHERE (m.material_id = mk.material_id) AND (k.keyword_id = mk.keyword_id) AND
word IN ('freedom', 'east timor')
GROUP BY title, mk.material_id
HAVING (COUNT(mk.material_id)) = 2
The above works well untill I have
word IN ('freedom', 'east timor') OR word IN ('australia')
how do I count for the material with the matching search words?
or should I use other join statements?
thanks for any tips or help!
annalise