SQL语句中修改查询结果集以后插入表中
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'
