Select Distinct A.SANCTION_ORDER_NO,A.SANCTION_ORDER_DATE,
D.FORCE_NO
From FM_TB_HOSTEL_SUBSIDY_SANCTION_HDR_T A join
FM_TB_HOSTEL_SUBSIDY_SANCTION_APPDTL_T B on A.SANCTION_ORDER_NO =B.SANCTION_ORDER_NO
join FM_TB_HOSTEL_SUBSIDY_SANCTION_DTL_T C on C.EMP_SEQ_NO =B.EMP_SEQ_NO And C.SANCTION_ORDER_NO =B.SANCTION_ORDER_NO
Join PM_TB_APP_APPOINTMENT_T D On D.EMP_SEQ_NO =B.EMP_SEQ_NO
Join PM_TB_MST_RANK_M E On D.PRESENT_RANK_CODE =E.RANK_CODE