Hello,

I was wondering if the following could be done with an advanced
sql-statement in MySQL 3.23:

I have 5 tables with the following columns: id, name, phonenumber
I need to check for duplicate phonenumbers in the 5 tables, that is if the
same phonenumber exists in 3 tables or more.

I've tried with a JOIN and a COUNT, but it doesn't seem to work.

Regards,
Frank Nørvig




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to