title: SQL Syntax for Joining tables while keeping the table name from which the data came
body: <p>There are two tables abcd,efgh:-</p>
  
  <p>abcd  – ID, salesdate, web, type.</p>
  
  <p>efgh  - ID, salesorderdate, event, web, mmid.</p>
  
  <p>combine them both with table name as one of the column it originated from</p>