title: Creating SQL View that checks for data in multiple tables
body: <p>So I have a sql table that will hold an ID like so </p>
  
  <pre><code>---------------------------------------------------
  | RecordID | Date | Price
  --------------------------------------------------
  | 1 | 8/31/2016 | 49
  --------------------------------------------------
  | 2 | 8/31/2016 | 101
  --------------------------------------------------
  </code></pre>
  
  <p>And I have 3 other tables that will hold information about this ID and can have different amount of columns</p>
  
  <pre><code>Table 1
  ---------------------------------------------------
  | RecordID | Date | Price | Name
  --------------------------------------------------
  | 1 | 8/31/2016 | 50 | System
  --------------------------------------------------
  Table 2
  ---------------------------------------------------
  | RecordID | Date | Price | Coupon
  --------------------------------------------------
  | 2 | 8/31/2016 | 100 | 7
  --------------------------------------------------
  </code></pre>
  
  <p>but the IDs are split between them. Meaning table 1 can have ID 1 then table 2 can have ID 2 and so on. An ID can only exist in one of the three tables. </p>
  
  <p>So my desire is to create a view where i can get the ID and price from the original table and find which table this ID exists in and put it all together nicely like this </p>
  
  <pre><code>---------------------------------------------------
  | RecordID | Date | Price1 | Price2
  --------------------------------------------------
  | 1 | 8/31/2016 | 49 | 50
  --------------------------------------------------
  | 2 | 8/31/2016 | 101 | 100
  --------------------------------------------------
  </code></pre>