SQL
| From: | Jonathan Underfoot | Date: | Tue, 19 Feb 2002 20:57:06 +0000 |
| Subject: | SQL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-17068@lists.php.net to get a copy of this message | ||
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