大神们,帮我找下问题呢。写SQL的时候,数据能查出来,当时做报表的时候却报错。 select a.ACTUAL "粘度",a.test_date_time "时间" from "WIP"."PARAMETRIC_MEASURE" as a,"WIP"."PARAMETRIC" as b where a.measure_name = 'MXCPS' and a.MEASURE_GROUP = 'NDZDSC' and right(b.RESOURCE_BO ,8)= 'MIXIV031' and a.TRANSACTION_ID=b.TRANSACTION_ID and a.test_date_time between '${DATEDELTA(TODAY(),-30)}' AND '${TODAY()}' |
最佳回答 |
||||
0
|
|