Finding duplicate values between several tables and appending this to a new table.
| From: | Norman Khine | Date: | Sun, 14 Dec 2003 22:53:01 +0000 |
| Subject: | Finding duplicate values between several tables and appending this to a new table. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-32058@lists.php.net to get a copy of this message | ||
Hello,
I have a database that has several tables, such as Company Name,
Address, Region, Employees.
I also have a table that contains similar sort of information as in the
first database, but this table has not been properly structured and just
contains a a record for each and every employee. It's a flat text file.
Now my question is there a way to compare the Company Name table,
against the Company Name field in the second table?
If there is,can you please provide me with basic examples so that I can
understand the principles, on how to do this?
Cheers
Norman