How to retrieve data of two columns from two tables?
Try following.

select T1.M_ID, 
    (select T2.T_NAME from TEAM_MASTER as T2 
    where T1.TEAM1_ID = T2.T_ID) as t1_Name,
    (select T2.T_NAME from TEAM_MASTER as T2 
    where T1.TEAM2_ID = T2.T_ID) as t2Name
    from MATCH_MASTER as T1;