Table Merge Successful, Primary Keys Missing

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