Finding mild duplication and combining what is'nt duplicated
Posted on 2005-05-17
Hi there - I am not sure where to start so I am looking for some advice. I have a database that holds all of my inventory, I would like to find out what pieces of information are duplicated and be able to copy certain things that are not duplicated.
Here is a visual
StockNo, Make, Model, ModelNo, Year, Options, Color, VIN, Pic1
So I want to find out all units that have the same Make, Model, ModelNo, Year, Options and Color these are considered identical units.
Then I want to find out if one of them has Pic1 = 0 if it does I would like to be able to click a check box on the webpage that will run a script that copies and renames pictures of the stockno with the stockno of the one that has pic's ( I can figure out the renaming of the files script ).
Maybe I should post this in the DB section? Don't know.