How can I create this table?

[affmark]

Hello,

I have 2 tables that I need to make into one.

This first table is called mct, contains all the products name, ids, descriptions, etc. The problem with this table is that it was built using a feed and contains many duplicate products.

The second table, mct2, contains only the product names but there are no duplicates.

Okay, so how can I make this one nice, neat table without the duplicates. Or how can I delete the duplicates from the first table? I have tried building a table using a select/ distinct statement but can't get it figured out.

Thanks

[pompopom]

why don't you make a SELECT query where you look for the id's of all the products with the same product name.

Then you do a DELETE query for all the id's except one...

[affmark]

Hi, I have tried something similar with the following:

SELECT mctid FROM `mct`, mct2 WHERE mct_title= mct2_title

This just gives me all the products in the table. I am not really sure how to write the select statement to get just the ones that have matching names.

[r937]

please do a search in the Databases forum, we've answered the "how do i remove all duplicates except one" several times

[affmark]

Thanks for the replies, I really appreciate it.

I was able to accomplish it by deleting the duplicates from table mct like so:

delete
from mct
group by mct_title
having count(*) > 1

Thanks again

[r937]

I was able to accomplish it

i hope you took a backup first

[affmark]

Yes, I did. Sorry, I should have mentioned that in the above post.