MSSQL INNER JOIN

select
A.*,
B.SLAB_T_TGT,
C.T_NSKD_AVG,C.T_SKID_AVG
from TBL_FUR_ZONE_OPT A
left join TBL_FUR_SLAB_INF B
on A.FCE_NO = B.FCE_NO
inner join TBL_FUR_SLAB_HIS C
on A.FCE_NO = c.FCE_NO
where A.FCE_NO = 1

이런식으로 원하는 항목만 쿼리 가능

select

A.SLAB_THK AS THK,

A.SLAB_WTH AS WTH,

A.SLAB_LTH AS LTH,

B.ELEC_PREDICT_VALUE AS EF_VALUE,

B.ELEC_PRICE AS EP_PRICE,

B.ELEC_PREDICTED_COST AS EP_COST

from Production_Schdule_Final A

Inner join production_Shedule_Predict B

on A.MTL_NO = B.MTL_NO

where B.RL_ROLL_UT_NM = {0}

order by B.CHARGE_START_DT asc