쿼리(조인 + 내부질의)

select
A.Coil_No,
A.Result_THK,
A.Result_WTH,
A.Result_WGT,
C.SLAB_NO
from Coil_Result A
left join Coil_Setting B
ON A.Coil_No = B.Coil_No
left join Production_Schedule_Final C
On B.Slab_No = C.SLAB_NO
Where A.Coil_No IN(select Coil_No from Coil_Setting where Slab_No = 'PP0004')