title: how to select 2 tables data using single query in MSSQL
body: <p>I am working on Library Management and for making a report I want to get data from 2 tables which are not interlinked i.e <code>issueData</code> and <code>issueRecord</code>.</p>
  
  <p>The Record contains previous book issued data while the Data table contains only the current book issued Report.</p>
  
  <p>Simply, I want to merge these two queries i.e</p>
  
  <ol>
  <li><code>Select * From issueRecord where issueDate = '19/07/2013'</code>.</li>
  <li><code>Select * From issueData where issueDate = '19/07/2013'</code>.</li>
  </ol>
  
  <p>Please Help.</p>