level 1
tgh360360
楼主
后台代码
SELECT tb_cl_xx.cl_one1_name,
tb_cl_xx.cl_two1_name,
tb_cl_xx.cl_ch,
tb_cl_xx.cl_id,
(select sum(yh_yl) from tb_zy_yh_xx where (yh_ch=tb_cl_xx.cl_id) and Year(yh_sj)=:nian and Month(yh_sj)=1),
(select sum(cl_yz_byyz) from tb_cl_yz_xx where Year(cl_yz_sj)=:nian and Month(cl_yz_sj)=5),
(select sum(cl_yz_byyz) from tb_cl_yz_xx where Year(cl_yz_sj)=:nian and Month(cl_yz_sj)=6)
FROM tb_cl_xx
提示:列名cl_yz_sj无效,后面的select 语句中where 一个参数时正常,加多一个后就这个提示,求解
2011年07月22日 02点07分
1
SELECT tb_cl_xx.cl_one1_name,
tb_cl_xx.cl_two1_name,
tb_cl_xx.cl_ch,
tb_cl_xx.cl_id,
(select sum(yh_yl) from tb_zy_yh_xx where (yh_ch=tb_cl_xx.cl_id) and Year(yh_sj)=:nian and Month(yh_sj)=1),
(select sum(cl_yz_byyz) from tb_cl_yz_xx where Year(cl_yz_sj)=:nian and Month(cl_yz_sj)=5),
(select sum(cl_yz_byyz) from tb_cl_yz_xx where Year(cl_yz_sj)=:nian and Month(cl_yz_sj)=6)
FROM tb_cl_xx
提示:列名cl_yz_sj无效,后面的select 语句中where 一个参数时正常,加多一个后就这个提示,求解