SQL语句中修改查询结果集以后插入表中解决方法

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
------解决方案--------------------------------------------------------

SQL code

insert into fmttxt_item(proj_code,tradecode,fmt_code,itemno)Select proj_code,tradecode,'3333',itemno from fmttxt_item where fmt_code='3303'