Hello, I am trying to insert client names into a client table from a 2nd table. The first table has a 2 column primary key(name and customer code). How can I get SQL server to insert the clients that are OK and leave out the ones that are not (or would be duplicates).<BR>thanks