字段加不上了

这个数据集之前可以改动，今天新加了个字段右边一直出不来请问有什么办法么

语句：select Delivery_Type,EXPRESS_NUM_AUTO, Prev_I_OUT_TICKET_TYPE,Prev_I_TICKET_TYPE,is_print,Prev_Ticket_Group_ID,DECI_UNITPRICE,vc_voucher_no,a.DT_UPDATEDATE,I_ORDER_ID,I_TICKET_QTY,DECI_TOTAL_AMT,I_VOUCHER_TYPE,DECI_DISCOUNT_AMT,DECI_ACTUAL_AMT,USER_NAME,GROUP_NAME,I_OUT_TICKET_TYPE,I_OUT_TICKET_GROUP_ID,I_TICKET_TYPE,DT_CREATEUSER,CUSTOMER_REALNAME,CUSTOMER_MOBILE,
--I_PAYMENT_AMT,
case when a.i_id=b.i_id then a.I_PAYMENT_AMT else 0 end as I_PAYMENT_AMT,
--PAYMENTTYPE,
--b.vc_name as PAYMENTTYPE,
b.group_01 as PAYMENTTYPE,
DT_EVENT_DATETIME,VC_PROGRAM_NAME_CN,ROW_NUMS,vc_remark,scs_another_name,Prev_Order from
(select Delivery_Type,EXPRESS_NUM_AUTO, Prev_I_OUT_TICKET_TYPE,Prev_I_TICKET_TYPE,is_print,Prev_Ticket_Group_ID,i_id,replace(WM_CONCAT(DECI_UNITPRICE),',','/') AS DECI_UNITPRICE,
vc_voucher_no,DT_UPDATEDATE,I_ORDER_ID,I_TICKET_QTY,DECI_TOTAL_AMT,I_VOUCHER_TYPE,DECI_DISCOUNT_AMT,DECI_ACTUAL_AMT,USER_NAME,GROUP_NAME,I_OUT_TICKET_TYPE,I_OUT_TICKET_GROUP_ID,I_TICKET_TYPE,DT_CREATEUSER,CUSTOMER_REALNAME,CUSTOMER_MOBILE,
I_PAYMENT_AMT,I_YUCUN_REAL_V,
PAYMENTTYPE,
DT_EVENT_DATETIME,VC_PROGRAM_NAME_CN,ROW_NUMS,replace(vc_remark,',','/') as vc_remark,scs_another_name,Prev_Order
from DBO.view_scs_viewer_021301_for_011
where vc_program_name_cn not like '%测试%' --AND vc_voucher_no='WH19123000216'
GROUP BY Delivery_Type,EXPRESS_NUM_AUTO,Prev_I_OUT_TICKET_TYPE,Prev_I_TICKET_TYPE,is_print,Prev_Ticket_Group_ID,i_id,vc_voucher_no,DT_UPDATEDATE,I_ORDER_ID,I_TICKET_QTY,DECI_TOTAL_AMT,I_VOUCHER_TYPE,DECI_DISCOUNT_AMT,DECI_ACTUAL_AMT,USER_NAME,GROUP_NAME,
I_OUT_TICKET_TYPE,I_OUT_TICKET_GROUP_ID,I_TICKET_TYPE,DT_CREATEUSER,CUSTOMER_REALNAME,CUSTOMER_MOBILE,I_PAYMENT_AMT,I_YUCUN_REAL_V,PAYMENTTYPE,DT_EVENT_DATETIME,VC_PROGRAM_NAME_CN,ROW_NUMS,vc_remark,scs_another_name,prev_order) a,
dbo.tbl_para_paymenttype b where b.b_enable=1 and DT_CREATEUSER>TRUNC(SYSDATE-500);

新加的字段：I_YUCUN_REAL_V

你最外层的抽取字段中，没有这个字段啊！！！
你得加上 a.I_YUCUN_REAL_V
select a.I_YUCUN_REAL_V,Delivery_Type,EXPRESS_NUM_AUTO, Prev_I_OUT_TICKET_TYPE,Prev_I_TICKET_TYPE,is_print,Prev_Ticket_Group_ID,DECI_UNITPRICE,vc_voucher_no,a.DT_UPDATEDATE,I_ORDER_ID,I_TICKET_QTY,DECI_TOTAL_AMT,I_VOUCHER_TYPE,DECI_DISCOUNT_AMT,DECI_ACTUAL_AMT,USER_NAME,GROUP_NAME,I_OUT_TICKET_TYPE,I_OUT_TICKET_GROUP_ID,I_TICKET_TYPE,DT_CREATEUSER,CUSTOMER_REALNAME,CUSTOMER_MOBILE,
--I_PAYMENT_AMT,
case when a.i_id=b.i_id then a.I_PAYMENT_AMT else 0 end as I_PAYMENT_AMT,
--PAYMENTTYPE,
--b.vc_name as PAYMENTTYPE,
b.group_01 as PAYMENTTYPE,
DT_EVENT_DATETIME,VC_PROGRAM_NAME_CN,ROW_NUMS,vc_remark,scs_another_name,Prev_Order from
(select Delivery_Type,EXPRESS_NUM_AUTO, Prev_I_OUT_TICKET_TYPE,Prev_I_TICKET_TYPE,is_print,Prev_Ticket_Group_ID,i_id,replace(WM_CONCAT(DECI_UNITPRICE),',','/') AS DECI_UNITPRICE,
vc_voucher_no,DT_UPDATEDATE,I_ORDER_ID,I_TICKET_QTY,DECI_TOTAL_AMT,I_VOUCHER_TYPE,DECI_DISCOUNT_AMT,DECI_ACTUAL_AMT,USER_NAME,GROUP_NAME,I_OUT_TICKET_TYPE,I_OUT_TICKET_GROUP_ID,I_TICKET_TYPE,DT_CREATEUSER,CUSTOMER_REALNAME,CUSTOMER_MOBILE,
I_PAYMENT_AMT,I_YUCUN_REAL_V,
PAYMENTTYPE,
DT_EVENT_DATETIME,VC_PROGRAM_NAME_CN,ROW_NUMS,replace(vc_remark,',','/') as vc_remark,scs_another_name,Prev_Order
from DBO.view_scs_viewer_021301_for_011
where vc_program_name_cn not like '%测试%' --AND vc_voucher_no='WH19123000216'
GROUP BY Delivery_Type,EXPRESS_NUM_AUTO,Prev_I_OUT_TICKET_TYPE,Prev_I_TICKET_TYPE,is_print,Prev_Ticket_Group_ID,i_id,vc_voucher_no,DT_UPDATEDATE,I_ORDER_ID,I_TICKET_QTY,DECI_TOTAL_AMT,I_VOUCHER_TYPE,DECI_DISCOUNT_AMT,DECI_ACTUAL_AMT,USER_NAME,GROUP_NAME,
I_OUT_TICKET_TYPE,I_OUT_TICKET_GROUP_ID,I_TICKET_TYPE,DT_CREATEUSER,CUSTOMER_REALNAME,CUSTOMER_MOBILE,I_PAYMENT_AMT,I_YUCUN_REAL_V,PAYMENTTYPE,DT_EVENT_DATETIME,VC_PROGRAM_NAME_CN,ROW_NUMS,vc_remark,scs_another_name,prev_order) a,
dbo.tbl_para_paymenttype b where b.b_enable=1 and DT_CREATEUSER>TRUNC(SYSDATE-500);

清理写缓存 重连下数据源，刷新下数据集

把sql取出来放在数据库底层能执行吗

另外，你这个SQL针对a和b，没有任何联立关系。。。 查出的结果会有重复数据吧？？
我没有看懂，你这个查询，联立dbo.tbl_para_paymenttype 这个表的意义何在。目前来看，没有任何意义，还有可能会使你的查询结果被复数化