'3' AND A.OLD_SAMPL_NO = ? ]]> '3' AND A.OLD_SAMPL_NO = ? ]]> '3' AND A.OLD_SAMPL_NO = ?) QQ full join (select A1.OLD_SAMPL_NO, max(DECODE(WI.CHEM_CD, 'C', WI.CHEM_VAL)) VALUE_C, max(DECODE(WI.CHEM_CD, 'Mn', WI.CHEM_VAL)) VALUE_Mn, max(DECODE(WI.CHEM_CD, 'S', WI.CHEM_VAL)) VALUE_S, max(DECODE(WI.CHEM_CD, 'P', WI.CHEM_VAL)) VALUE_P, max(DECODE(WI.CHEM_CD, 'Si', WI.CHEM_VAL)) VALUE_Si, max(DECODE(WI.CHEM_CD, 'Ti', WI.CHEM_VAL)) VALUE_Ti, max(DECODE(WI.CHEM_CD, 'N', WI.CHEM_VAL)) VALUE_N from c_tbk02_coil_comm A1, TBB02_WORK_INGR WI, TBG02_CHARGE_COMM_D D where A1.OLD_SAMPL_NO = ? AND A1.COIL_STAT <> '3' AND WI.CHARGE_NO = D.CHARGE_NO AND WI.PROC_CD || WI.CHEM_SEQ = D.LST_INGR_CD AND SUBSTR(A1.SLAB_NO, 1, 10) = WI.CHARGE_NO AND WI.CHEM_CD IN ('C','Mn','S','P','Si','Ti','N') GROUP BY A1.OLD_SAMPL_NO) CC on QQ.OLD_SAMPL_NO = CC.OLD_SAMPL_NO ]]> '3' ]]>