I learnt about INTERSECT when I had a query which I couldn't write any other way.

http://sci.esa.int/science-e/www/object/index.cfm?fobjectid=30910

you see there are missions and topics, and an option of Match Any...

Thanks for responses,

Ed, your query worked almost perfectly for me... though I did ammend it slightly.

SELECT Res.RANK AS RANK, primary_id, id, title, released, category, rrp, thumbnailurl, minimumprice

FROM    dbo.tbl_dvds INNER JOIN...