Re: advanced statement

2003-06-03 Thread Neil Zanella
On Mon, 2 Jun 2003, Frank Nørvig wrote: > 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

advanced statement

2003-06-02 Thread Frank Nørvig
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