How about real something simple:
1. Create a table to hold the autoincrement value plus the concatenation of
all the columns that you need. So you end up with a 2 column table. The
second column is just a long string, so you have to CAST some numeric values
into CHAR
2. At this point you can SELECT DISTINCT the second column along with the
autoincrement id.
3. Then you can go back into your original table with a WHERE based on the
auto id.
Get it? If you would post your CREATE TABLE along with some INSERTS, it
would make it easier.
"zaphod" <no**@none.com> wrote in message
news:43***********************@ptn-nntp-reader04.plus.net...
I need to select unique combinations of 4 columns from one table and
insert them into a new table but I can't think of any way of finding unique
combinations of more than 1 column since SELECT DISTINCT only works on
single columns. Any ideas?
zaphod