title: How can I do a switched outer join with more than one table in SQL Server 2012?
body: <p>I have the following select</p>
  
  <pre><code>        Select Exam.Name, 
                 Test.Type,
                 Test.TestId, 
                 Topic.Name, 
                 Exam.Name
          FROM Test
          INNER JOIN Exam
             ON ( Test.ExamId = Exam.ExamId)
          INNER JOIN Topic
             ON ( Test.TopicId = Topic.TopicId)
          WHERE Test.TestStatusId = 1
  </code></pre>
  
  <p>When Test.Type = 1 then there will be an Exam.Name for the test
  When Test.Type = 2 then there will be a Topic.Name for the test</p>
  
  <p>Is there a way I can do an outer join and just return Name based on if Type = 1 or 2 ?</p>