title: Joining two columns into one column from different tables
body: <p>I am using SQL Server 2008. I have two sql queries</p>
  
  <pre><code>select Course 
  from StudentDB.dbo.Student 
  where RollNo = 130
  </code></pre>
  
  <p>and</p>
  
  <pre><code>select Course 
  from StudentDB.dbo.Courses 
  where Course is not null
  </code></pre>
  
  <p>First query will return the following value</p>
  
  <pre><code>MSc
  </code></pre>
  
  <p>and the second query will return </p>
  
  <pre><code>MCA
  MSc
  CSE
  ECE
  EEE
  </code></pre>
  
  <p>I need to join these queries and want an output like this</p>
  
  <pre><code>MSc
  MCA
  CSE
  ECE
  EEE
  </code></pre>
  
  <p>That is appending the result of second query to the first query and removing the duplicate value. </p>
  
  <p><strong>Please note</strong> I need result of first query on the top of the result. Here Msc is the first value because it is the result of first query. I tried union. But it returns the result of the second query itself. So union of those queries won't helps.</p>