RE: [PHP-DB] SQL

How could you possibly have such a condition exist? That is, what relation do the counts have to the contents of the name field? What ARE you trying to really accomplish? -----Original Message----- From: Jonathan Underfoot [mailto:jonathan@underfoot.cc] Sent: Tuesday, February 19, 2002 2:57 PM To: [PHP-DB] Subject: [PHP-DB] SQL Is it possible to do a comparison of values from a count... for example... SELECT table1.name, count(table1.name) as num1, count(table2.name) as num2 FROM table1, table2 WHERE table1.name = table2.name AND num1 = num2 This sort of thing dosent work for me. How do I reffrence a count later in the where clause? Thanx -Jonathan