select /*+ordered(x,y)*/ sik_ts, bin_no,HYK_CD2,HYK_CD3,
SKTIT_SIGN+SKTIT_TEXT SKTIT
from (
select SEHN_HIN_CD, LOT_NO, BSEI_CD,,KIJ_SEQ,
min(decode(HYK_JKN_KMK_CD,'2',HYK_JKNT)) HYK_CD2,
min(decode(HYK_JKN_KMK_CD,'3',HYK_JKNT)) HYK_CD3
from TableA
where SEHN_HIN_CD = :V1 -- 'KM73Y-9'
and LOT_NO = :V2 -- '5AK017'
and BSEI_CD = :V3 -- '8033'
group by SEHN_HIN_CD, LOT_NO,BSEI_CD,KIJ_SEQ
) x, TableB y
where x.SEHN_HIN_CD = y.SEHN_HIN_CD
and x.LOT_NO = y.LOT_NO
and x.BSEI_CD = y.BSEI_CD
and x.KIJ_SEQ = y.KIJ_SEQ;
|