insert into price_vs_insur(item_class,item_code) (select item_class,item_code from price_list where item_code not in(select item_code from price_vs_insur)); 批量插入数据时不能有values关键字的!
用第一位兄弟的方法insert into price_vs_insur(item_class,item_code) (select item_class,item_code from price_list where item_code not in(select item_code from price_vs_insur));
(select item_class,item_code from price_list where
item_code not in(select item_code from price_vs_insur));