过滤条件是
[母子手册发放_主表].[是否结案] <> '结案' 并且 [母子手册发放_主表].[手册编号] NOT IN ( 本报表.[母子手册随访_明细表].[手册编号] )
怎么执行会出错?
从数据类型 varchar 转换为 numeric 时出错。
SELECT DISTINCT T_19.F_476 AS F_509xFN,
T_19.F_478 AS F_510xFN,
T_19.F_479 AS F_511xFN,
T_19.F_483 AS F_512xFN,
T_19.F_484 AS F_513xFN,
T_19.F_481 AS F_514xFN,
T_19.F_477 AS F_515xFN,
T_19.F_475 AS F_516xFN
FROM T_19 , T_21 WHERE 1=1 AND [T_19].[F_506] <> '结案' AND [T_19].[F_476] NOT IN ( '' ) |
|
yfy2018