Help needed with Duplicates/Unique values

G'day!

I was re-working an old table, and I decided to try to find a unique key on it, I found 2 columns that were likely so I did a check to see if they were unique , and I found a ton of duplicates. Turns out that for each 'key' there were a number of values in a column.

So, I want to put that column in it's own table (otherwise there is a SICK amount of duplicated data), before I do this, I need to make sure that without this column, everything is fine (no duplicates, my 'key' is a unique key).

What is an easy way to do this?

Stay Casual,

Ken

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Feb 26 1998 - 00:00:00 CST