Had you provided CREATE TABLE + INSERT statements for the sample data, I would have tested my query. This is untested.
SELECT ...
FROM Table2 T2
WHERE EXISTS (SELECT *
FROM Table1 T1
WHERE T2.Type = T1.Type
AND T2.Name = T1.Name)
UNION ALL
SELECT ...
FROM Table2 T2
WHERE NOT EXISTS (SELECT *
FROM Table1 T1
WHERE T2.Type = T1.Type)