insert into A(experience_id, experience_title) values(max(experience_id) + 1, '123') select t.experience_id, t.experience_title from B t
但是那样是不能用分组函数吗。大家有什么办法吗？帮帮忙谢谢分组函数？ 用merge into 来插入吧 SQL code: insert into A(experience_id, experience_title) select t.experience_id, t.experience_title from B t where t.experience_id not in (select experience_id from A)
experience_id是主键？ +1就为了不重复？
是的 insert into A(experience_id, experience_title) select t.experience_id, t.experience_title from B t where t.experience_id not in (select experi
