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")