[snip] What about select distinct a.region, a.city from mytable a , mytable b where a.region=b.region and a.city <> b.city [/snip]
Crud! Standing too close to the forest and forgot about a self join... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]