Hi, I would like to copy rows from one table to another while copying only the first row from sets of similar rows.
In particular, for rows in which two particular fields are the same, I would like to copy only the first row in that set. The rows have more than these two fields. I know how to copy rows from one table to another, but how do I suppress similar rows in this way? Amir
