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