FROM WK_BOM T1

DB_WK T2

WHERE T1.ID = T2.ID

AND T1.REV = T2.REV

AND T1.NO ='S1234'

AND T1.KND ='FOSET'

AND NOT EXISTS (SELECT 1

FROM WK_BOM

WHERE ID = T1.ID

AND REV > T1.REV);

------------------------------------------------------

FROM (

SELECT * FROM (

SELECT BOM.*,

ROW_NUMBER() OVER(PARTITION BY ID ORDER BY ID,REV DESC ) RN

FROM WK_BOM BOM

WHERE NO='S1234'

AND KND = 'FOSET')

)

WHERE RN=1

) T1,

DB_WK T2

WHERE T1.ID = T2.ID

AND T1.REV = T2.REV ;

PK : ID, REV

마농님의 자료를 보다가 위처럼

고쳐 봤는데...데이터 일부분이 다르게 나오네요. ^^

제가 잘못한게 어디죠 ^^;