救命呀…這裡有人會sql的嗎..............

試著喚起多年前的記憶  好像是這樣
insert into warehouse(cost) select (Price) from product
當然你可以在cost 和price多加欄位  i.e. (cost, sn)  and (Price, num) ..