Compare two text string same field between two different tables to identify Match/No Match

Hi Team, I am trying to compare the Room Name between two tables to Match/No Match. I am using below logic to comapre Room Name field between Table 1 and Table 2  The below query dosen't seems to p...