title: How to fetch data from two different tables in SQL
body: <p>I'm trying to fetch the records from two different tables in the same database. But I encounter an error.</p>
  
  <p>Query:</p>
  
  <pre><code>use AdventureWorks2014
  
  select 
      cast(departmentID as nvarchar), ModifiedDate 
  from 
      [HumanResources].[Department]
  union
  select 
      LoginID, JobTitle 
  from 
      [HumanResources].[Employee]
  </code></pre>
  
  <p>Error:</p>
  
  <blockquote>
    <p>Msg 241, Level 16, State 1, Line 2<br>
    Conversion failed when converting date and/or time from character string.</p>
  </blockquote>
  
  <p>I appreciate your help. </p>
  
  <p>Thanks All</p>