I need to get some duplicate record information from a table and I
haven't found any way to do it yet. I figured there might be some type
of query I could do using a "for each" type command.
What I have is a table with names and companies. Some people have
multiple entries for different companies. What I need to get is the name
that has multiple entries along with the company names.
Name | Company
------------------------
Joe Blow Company 1
Joe Blow Company 2
Joe G. Blow Company 1
Running the query should only return Joe Blow with Company 1 and Company 2.
I can find out how many records Joe Blow has or list out each Company
record grouped by Name but I only want Names with multiple entries
shown. Can anyone help? I'm sure this also makes a difference but I'm
stuck using MySQL 3.23.
Thanks,
Ed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
