SQL Server查询 - 如果不匹配，则返回null值

I'm running into a problem that I cannot figure out for some reason. I am trying to write a query that joins two tables, in which a match may not be found in a table. Such as:I'm running into a problem that I cannot figure