Try
SELECT file_id, file_no, DM1.Designation_name AS from_Designation, DM2.Designation_name AS to_Designation
FROM File_Master F
LEFT JOIN Designation_Master DM1 ON F.from_Designation_id = DM1.Designation_id
LEFT JOIN Designation_Master DM2 ON F.to_Designation_id = DM2.Designation_id