title: How to read multiple tables as a single table
body: <p>While converting an old VB program to a .NET program, the project manager has decided that we need to have a separate tables for the old (vb) Data and the new (.NET) data.</p>
  
  <p>this is where it kinda gets confusing. In order for the .net version to backwards compatible, We need the .NET version to read from both the .Net tables and the old VB tables.</p>
  
  <p>is there some way to have my sql statement read from both tables and treat them as if they a single table?</p>
  
  <p><strong>example:</strong></p>
  
  <p><strong>VB Table:</strong></p>
  
  <p>Johan Bach</p>
  
  <p>Ludwig Beethoven</p>
  
  <p><strong>.NET Table:</strong></p>
  
  <p>Wolfgang Motzart</p>
  
  <p>Johannes Brahms</p>
  
  <p><strong>SQL will pull this:</strong></p>
  
  <p>Johan Bach</p>
  
  <p>Ludwig Beethoven</p>
  
  <p>Wolfgang Motzart</p>
  
  <p>Johannes Brahms</p>