开发者

Crystal Reports select statement help

开发者 https://www.devze.com 2023-01-29 18:01 出处:网络
I\'m attempting to add the MV_AgeBased and the MV_FeeInLieu columns, however some of the columns may have null or empty in the db, this results in bringing back zeroes for that CodeEntity.Any suggesti

I'm attempting to add the MV_AgeBased and the MV_FeeInLieu columns, however some of the columns may have null or empty in the db, this results in bringing back zeroes for that CodeEntity. Any suggestions?

        SELECT "AuditorYearEnd"."PP_MH_Pri", "AuditorYearEnd"."PP_MH_Other", 
"County"."Name", "AuditorYearEnd"."TOT开发者_如何学PythonAL_Personal_calc", 
"AuditorYearEnd"."PP_BusPersonal", "AuditorYearEnd"."TaxYr", 
"AuditorYearEnd"."CodeEntity", "AuditorYearEnd"."MV_AgeBased", 
"AuditorYearEnd"."MV_FeeInLieu"
     FROM   "txctr"."dbo"."AuditorYearEnd" "AuditorYearEnd" 
INNER JOIN "txctr"."dbo"."County" "County" ON "AuditorYearEnd"."CodeCounty"="County"."CodeCounty"
     WHERE  "AuditorYearEnd"."TaxYr"=2010 AND "AuditorYearEnd"."CodeEntity"='1010'


    SELECT "AuditorYearEnd"."PP_MH_Pri", "AuditorYearEnd"."PP_MH_Other", 
"County"."Name", "AuditorYearEnd"."TOTAL_Personal_calc", 
"AuditorYearEnd"."PP_BusPersonal", "AuditorYearEnd"."TaxYr", 
"AuditorYearEnd"."CodeEntity", "AuditorYearEnd"."MV_AgeBased", 
"AuditorYearEnd"."MV_FeeInLieu"
 FROM   ("txctr"."dbo"."AuditorYearEnd" "AuditorYearEnd" 
INNER JOIN "txctr"."dbo"."County" "County" ON "AuditorYearEnd"."CodeCounty"="County"."CodeCounty"
 WHERE  "AuditorYearEnd"."TaxYr"=2010 AND "AuditorYearEnd"."CodeEntity"='1010')

Add "WHERE [column] is not null" for all the potentially null columns?

Not absolutely sure what is being asked, here.

0

精彩评论

暂无评论...
验证码 换一张
取 消