错误提示:无法绑定由多个部分组成的标识符 "a1.S2"。
错误sql:
SELECT
*
from
(SELECT
a1.ID ,
a2.M1 as ID1 ,
a3.NAME as ID2 ,
M1 = case a1.M1
when 0 then '否'
when 1 then '是'
end ,
M2 = case a1.M2
when 0 then '否'
when 1 then '是'
end,
a1.M3 ,
a1.S1 ,
a1.S2,
a1.S3
FROM
issue_filetransmissionreceiving as a1 ,
issue_securityfilerelease as a2,
t_user as a3
where
a1.ID1=a2.ID
and a1.ID2=a3.ID )
AS a
WHERE
1=1
AND a1.S2 <='2017-06-28 23:59:59'
参照代码:
SELECT
*
from
(SELECT
a1.ID ,
a2.M1 as ID1 ,
a3.NAME as ID2 ,
M1 = case a1.M1
when 0 then '否'
when 1 then '是'
end ,
M2 = case a1.M2
when 0 then '否'
when 1 then '是'
end,
a1.M3 ,
a1.S1 ,
a1.S2,
a1.S3
FROM
issue_filetransmissionreceiving as a1 ,
issue_securityfilerelease as a2,
t_user as a3
where
a1.ID1=a2.ID
and a1.ID2=a3.ID )
AS a
WHERE
1=1
参考代码和错误代码差别就是参考代码少了一个条件,所以,判断错误代码的原因是条件错了,有以下两个修改方法。仅供参考。
修改方法:把a1改成a
把 a1.S2 <='2017-06-28 23:59:59' 这个条件加到内查询中的条件后面