How can I create this table?
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.