Mysql query

[swedguy]

F I N A L L Y !


SELECT sponsor, COUNT(keyword) AS cnt FROM (
SELECT sponsor, keyword FROM banners WHERE keyword LIKE 'horizontal'
UNION
SELECT sponsor, keyword FROM banners WHERE keyword LIKE 'vertical'
UNION
SELECT sponsor, keyword FROM banners WHERE (keyword LIKE 'small' OR keyword LIKE 'button')
) AS tbl
GROUP BY sponsor HAVING cnt = 3


1 query

Thanks Sparky, you got me on the right track there with the count(). Thanks