In each database I have a table with one column I want to compare and then count. So db1.a.odip and db2.aa.newip are the databases, table and coulumns.
The data in each column is Ip's, so my result would be a list and count for each by subnet. So the result would be like: db1.a.odip count ------------ ------- 10.10.10. 30 192.168.5. 10 db2.aa.newip count ------------ ------- 10.10.10. 20 192.168.5. 40 I can parse two select statement to a perl script, but was wondering if this can be done in a select statement. Thanks, Rob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]