title: SQL Combine two tables in a View
body: <p><img src="https://i.stack.imgur.com/C5dkg.jpg" alt="Simple Table Diagram"></p>
  
  <p>I have three tables (simplified table diagram above).  From these three tables I would like to create a view that would be the combination of TableA and TableB (all rows from tableA and all from TableB with no duplicates).  The catch is I don't want the foriegn keys from TableA but instead I want the names from TableC in the view.  A row would something like below</p>
  
  <p>Id, FullName_A, FullName_B</p>
  
  <p>Is this possible?</p>