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