select * from v_inp_orders where
orderdept!=6 and prestatus not in (8) and isdelete='0'
and direcode in('03','25','59','92','114','119','115','116','117','46','02','04','06','11','37','51','10','47',
'62','63','64','65','66','67','104','80','81','107','121')
order by reg_no,pre_no,groupno
union all
select * from v_inp_orders_all where
orderdept!=6 and prestatus not in (8) and isdelete='0'
and itemcode in('SF0083','SF7970','SF9141','SF0068','SF0095','SF0076','SF0130','SF0067','SF9117',
'SF6812','SF0065','SF0064','SF0116','SF0117','SF0115','SF0131','SF0069','SF0573',
'SF0655','SF0114','SF0124','SF6987','SF6996')
order by reg_no,pre_no,groupno
就是这个语句，提示语句未正确结束，然后我把上面的order by注释掉之后提示无效标识符，希望各位高手指导一下。
------解决方案--------------------
1. union all 不能加 order by
2. union all 中，select 字段必须相同，上面有几个字段，下面也要几个字段，顺序要相同
------解决方案--------------------