db2 query insert from another table

db2

Solution

I believe you are looking for:

insert into  productHistory 
       ( id_h
       , id_product 
       , name
       ) 
  select next value for product_history_seq
       , id_product 
       , name 
    from product 
;

Problem

I have a table product(id_product , name ); I have another one: productHistory (id_H , id_product , name); I wanna create a query (db2) to insert all the rows of product in productHistory; I have a sequence product_history_seq I wanna do something like that: ``` insert into productHistory (id_h , , id_product , name) values ( product_history_seq.nextval,.. ``` Or, ``` select (id_product , name) from product ``` What's the correct query?

Original source