On Mon, 21 Feb 2005 15:09:53 -0500 (EST), john at johnallsopp.co.uk wrote: > I'm using mySQL, so no subselections are allowed. So I'm heading into > temporary tables. Here's what I have so far: If you mean nested queries, they are allowed in MySQL >= 4.1 http://www.mysql.com/products/mysql/ Does this help? James