From: "Adriano Castro" <ad at netvisao.pt> Sent: Tuesday, March 30, 2004 5:19 PM Hello. > How can I do this using a simple SQL query? If you use MySQL you probably could use subqueries: For version 4.1: http://www.mysql.com/documentation/mysql/bychapter/manual_SQL_Syntax.html#Subqueries For earlier versions (like 4.0): http://www.mysql.com/documentation/mysql/bychapter/manual_SQL_Syntax.html#Rewriting_subqueries Best regards, @778, Nbk P.s. - Lols. http://temp.adrianocastro.net/archives/000157.html :-)