The first sql will give null for field r1 while the second will give correct value("Orange Assembly Line). Can someone help with first because I need a condition in the statement. This is db2 database.

testconnString = "Select webprddt1.qartmast.recseq, locindex," +;
" CASE When locindex > 20 THEN 0 ELSE (Select ssrcdef From webprddt1.qartsubsdf Where recseq = locindex) END As r1 " +;
" From webprddt1.qartmast" +;
" join webprddt1.qartsubsrc On webprddt1.qartsubsrc.rtindex = webprddt1.qartmast.recseq" +;
" Where webprddt1.qartmast.recseq = 1594901"

testconnString = "Select webprddt1.qartmast.recseq, locindex," +;
" (Select ssrcdef From webprddt1.qartsubsdf Where recseq = locindex) As r1 " +;
" From webprddt1.qartmast" +;
" join webprddt1.qartsubsrc On webprddt1.qartsubsrc.rtindex = webprddt1.qartmast.recseq" +;
" Where webprddt1.qartmast.recseq = 1594901"