If Table1 contains more data then Table2, try this:
SELECT t1.id, CASE WHEN t2.id IS NULL THEN 'Unmatched' ELSE 'Matchaed' END AS 'CompareResult'
FROM Table1 AS t1 LEFT JOIN Table2 AS t2 ON t1.id = t2.ID
Idea: get all data from Table1 and only these data which are equal in table2. If id in table2 is NULL, then it means 'Unmatched'.