Table Merge Successful, Primary Keys Missing

[<operationsengineer1(at)yahoo(dot)com>]

i'm trying to merge two tables together.

i'm able to do it with...

select * 
into t_temp_final
from t_temp_output
union
SELECT * FROM t_product
; 

however, i lost all my primary key values in
t_temp_final

i can't create a pkey now b/c i have 1000 null values.

how can i get around this situation?

tia...

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com