Results 1 to 7 of 7
Thread: How can I create this table?
Jan 15, 2006, 14:05 #1
- Join Date
- Dec 2005
- 0 Post(s)
- 0 Thread(s)
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.