Re: Table Merge Successful, Primary Keys Missing

clarification below...

--- operationsengineer1(at)yahoo(dot)com wrote:

> 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...

the current t_product table entries have product_id
values. the temp table doesn't. so i need to add
product_ids wher where product_id IS NULL.

if i knew how to create a serial field (and control
its values to start at a level greater than the
highest t_product product_id value) in an insert into
temp table, i could create product_ids when i create
the insert into temp table and then merge everything
together - complete with product_ids in place.

is this the best way? if so, how can i work in a
serial field when doing an insert into?

tia...

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