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

Reply via email to