insert into fmttxt_item(proj_code,tradecode,fmt_code,itemno)
Select proj_code,tradecode,'3333',itemno from fmttxt_item
where fmt_code='3303' order by itemno)
请问这样的语句有何问题?如果不对,应该做什么样的修改?
------解决方案--------------------
仔细看看
insert into fmttxt_item(proj_code,tradecode,fmt_code,itemno)
Select proj_code,tradecode,'3333',itemno from fmttxt_item
where fmt_code='3303' order by itemno
insert into fmttxt_item(proj_code,tradecode,fmt_code,itemno)
Select proj_code,tradecode,'3333',itemno from fmttxt_item
where fmt_code='3303' order by itemno)