菜问题,立结贴!
//可以直接看where语句后的条件
select distinct wa_data.pk_wa_data , wa_data.psnid , wa_data.psnclid , wa_data.deptid , wa_data.istopflag , bd_psndoc.psncode 人员编码, bd_psndoc.psnname 人员姓名, bd_deptdoc.deptname 所在部门, bd_psncl.psnclassname 人员类别, wa_data.classid , wa_data.cyear , wa_data.cperiod , wa_data.irecaculateflag , bd_accpsndoc.id , bd_accpsndoc.ssnum , bd_accpsndoc.timecardid , wa_data.f_101 职位系列, wa_data.f_102 职位等级, wa_data.f_15 职位工资, wa_data.f_17 绩效基数, wa_data.f_16 绩效工资考核计发额, wa_data.f_27 其它补贴, wa_data.f_25 其他, wa_data.f_36 应发工资合计, wa_data.f_20 养老统筹, wa_data.f_22 住房公积, wa_data.f_23 教育基金, wa_data.f_26 工会会费, wa_data.f_33 个人所得税, wa_data.f_24 扣款1, wa_data.f_38 扣款2, wa_data.f_29 奖金, wa_data.f_37 实发工资合计
from wa_data , bd_psndoc , bd_psncl , bd_deptdoc , bd_accpsndoc ,wa_psn
where wa_data.classId = '1001AA100000000004F6'
and wa_data.cyear = '2003'
and wa_data.cperiod = '12'
and wa_data.psnid = bd_psndoc.pk_psndoc
and wa_data.psnclid = bd_psncl.pk_psncl
and wa_data.deptid = bd_deptdoc.pk_deptdoc
and wa_data.psnid = bd_accpsndoc.pk_psndoc
and wa_data.dr = 0
and wa_data.istopflag = 0
and wa_data.psnid = wa_psn.psnid
--
and ltrim(rtrim(wa_psn.vacccode)) = ''
//返回165行
将 and ltrim(rtrim(wa_psn.vacccode)) = '' 改为 <> ''
//返回160行
//但我希望的是要那5行的,这是怎么回事啊?(vacccode是varchar(50)的)