根据加入ID显示两个不同列中的值

I'm trying to create a select statement for SQL Server, as per the title. My data is:I'm trying to create a select statement for SQL