You've left a few questions unanswered, such as: What are the keys?
What if there is more than one person with the same name? Here's one
SELECT t1.name, t2.name
FROM table1 AS t1
LEFT JOIN table2 AS t2
ON t1.sirname = t2.sirname
AND NOT EXISTS
WHERE sirname = t1.sirname
AND name > t1.name);
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online: