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?
From: Jonathan Underfoot [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 2:57 PM
Subject: [PHP-DB] SQL
Is it possible to do a comparison of values from a count...
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?
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php