SELECT
dbo.FNT_IP_KEEP.IP_AN ,
dbo.FNT_IP_KEEP.PB_REQ_CD as cc,
dbo.PHM_DRUG.PH_UNIT_DES,
dbo.SVM_CODE.SV_UNIT
FROM
dbo.FNT_IP_KEEP
LEFT OUTER JOIN dbo.PHM_DRUG ON dbo.PHM_DRUG.PH_DRUG_CD = dbo.FNT_IP_KEEP.PB_REQ_CD
LEFT OUTER JOIN dbo.SVM_CODE ON dbo.SVM_CODE.SV_CD = dbo.FNT_IP_KEEP.PB_REQ_CD
WHERE
dbo.FNT_IP_KEEP.IP_AN = '2558000920' AND
dbo.FNT_IP_KEEP.PB_REQ_CD IN ('1NEE-03', 'OR040')