Kevin Sedgley wrote:
>
> I was thinking something like SELECT * FROM categories, categories WHERE
> category = "cheese" AND category = "stilton" (so combining the same table
> twice) but this isn't allowed.
It certainly IS allowed, but you don't need to express the table twice.
SELECT
*
FROM
categories
WHERE
category IN ("cheese","stilton")