在使用TableAdapter查询配置向导来构建SQL查询语句时检查报错,我键入的语句如下:
SELECT T1.BJ_ID,
T2.BJ_NAME,
T2.BJ_MODEL,
T1.OUTPUT_COUNT,
CASE T1.DELIVERYTYPE
WHEN 'A' THEN
'领用'
ELSE
'核减'
END AS DELIVERYTYPE,
nvl(t1.memos, '无') AS memos,
TRUNC(T1.OUTPUTDATETIME, 'DD') AS OUTPUTDATE,
T3.MEMBER_NAME AS RECEPTOR_NAME,
T4.MEMBER_NAME AS OPERATOR_NAME
FROM BEIJIANOUTPUT T1,
BEIJIANINFO1 T2,
BANMEMBERSINFO T3,
BANMEMBERSINFO T4
WHERE T1.BJ_ID = T2.BJ_ID
AND T1.RECEPTOR_ID = T3.MEMBER_ID
AND T1.OPERATOR_ID = T4.MEMBER_ID
AND (T1.PRINTSTATUS = 1)
报错如图
但该语句我直接在plsql上执行完全没有问题,实在不明白怎么回事,请教高手!