Insert the value from 1 table into another SQL 2008

[sarticle]

I have the following SQL. I am trying to insert the \[code\]ClientName\[/code\] from \[code\]Clients\[/code\] into the \[code\]pName\[/code\] column in \[code\]CommisionPickups\[/code\]. I need to make sure that all the values are unique. \[code\]insert into CommisionPickups (pName) (select ClientName from Clients where ClientName <> CommisionPickups.pName)\[/code\]