As for the SQL query, I should check the docs then try the query in practice, but that would take more time, so I can't afford for free. If you use MySQL 4.x, it allows nested queries, so makes possible to do the task without temp table.
Maybe some SQL guru may give you quick & free answer without checking the docs...

Best regards,
Webmaster33

---

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...