Here is an example. I want to have two fields as primary keys. Do I just add

Primary key as stated ?

SELECT distinct

TOP 100 PERCENT

[Client ID] Primary Key,

[Account Number] Primary Key, [Proj Black 1% Depr Month],

[Proj Black Str Adj],

[Proj Black Sea Adj],

[Black Book Straight Proj Loss],

[Black Book Seasonal Proj Loss],

into ProjGLClient

FROM dbo.CLNTtemp5

ORDER BY [Client ID], [Account Number]