SELECT T.YMD_ID, --年月日 T.LEVEL_4_NAME, --销售区 T.DEPARTMENT_NAME, --代表处 T.PERSONNEL_NAME, --终端经理 T.PERSONNEL_PARENT_NAME, --区域经理 T.HEALTH_CONSULTANT_NAME, --养生顾问 --T.HEALTH_CONSULTANT_PHONE, --养生顾问手机号 T.HEALTH_CONSULTANT_TYPE, --养生顾问类型 T.HEALTH_CONSULTANT_STATUS, --养生顾是否在岗 T.CUSTOMER_CODE, --门店客户编号 T.CUSTOMER_NAME, --门店 --T.CUSTOMER_TYPE, --门店类型 T.CONSUMER_NAME, --消费者姓名 T.CONSUMER_PHONE, --消费者电话 T.CONSUMER_SEX, --消费者性别 T.CONSUMER_GOAL_BUY, --购买目的 T.AOJIAO_DATE, --熬胶时间 T.PRODUCT_NAME, --产品名称 T.PRODUCT_BATCH, -- 产品批号 T.PRODUCT_YM, -- 产品年月 T.AOJIAO_TYPE, --熬胶类型 T.SCAN_TYPE, --扫码类型 T.ORDER_FROM, --订单来源 T.ORDER_ID, --订单ID --'@'||T.SECURITY_CODE, --防伪码 T.AOJIAO_STD_NM, --本期熬胶数量（盒） T.AOJIAO_CVT_NM, --本期熬胶数量（KG） T.ACCESSORY_STD_NM, --辅料量（包） T.ACCESSORY_STD_NM --辅料量FROM ADS_AJ_AOJIAO_DETAIL Twhere 1=1-- 查询条件${if(len(startDate) == 0,"","AND T.YMD_ID >= '" + startDate + "'")} ${if(len(endDate) == 0,"","AND T.YMD_ID <= '" + endDate + "'")}${if(len(xsq) == 0,""," and T.LEVEL_4_NAME ='" + xsq + "'")}${if(len(dbc) == 0,""," and T.DEPARTMENT_NAME ='" + dbc + "'")}${if(len(md) == 0,"","AND T.CUSTOMER_NAME like '%" + md + "%'")} ${if(len(xsjl) == 0,"","AND T.PERSONNEL_NAME like '%" + xsjl + "%'")} ${if(len(gw) == 0,"","AND T.HEALTH_CONSULTANT_NAME like '%" + gw + "%'")} ${if(len(gwType) == 0,"","AND T.HEALTH_CONSULTANT_TYPE = '" + gwType + "'")} ${if(len(ORDER_FROM) == 0,""," and T.ORDER_FROM ='" + ORDER_FROM + "'")}${if(len(code) == 0,"","AND T.SECURITY_CODE = '" + code + "'")} ORDER BY T.YMD_ID, T.LEVEL_4_NAME, T.DEPARTMENT_NAME, T.HEALTH_CONSULTANT_NAME, T.CUSTOMER_NAME这边报未明确定义列，但是数据集中没有用表链接啥的呀，这个要怎么修改呀
