title: Alternative for full outer join in indexed view
body: <p>I want to display records from two tables.</p>
  
  <p>It should return all the matching records from both the tables.</p>
  
  <p>If a record is present in first table and not present in second table it should return null from the Second table and records from the first table.
  If a record is present in second table and not present in first table it should return null from the first table and records from the second table</p>
  
  <p>I don't want to use a <code>full outer join</code>, because I want to create an indexed view and outer(Left, Right, Full) joins are not allowed in Indexed View.</p>
  
  <p>Is there any better solution for this scenario.</p>