title: SQL Server replaces LEFT JOIN for LEFT OUTER JOIN in view query
body: <p>I need to use a LEFT JOIN in a View however SQL Server replaces LEFT JOIN for LEFT OUTER JOIN every time I save my view.</p>
  
  <p>When trying to use LEFT INNER JOIN explicitly I get the error "Incorrect syntax near word 'INNER'". What is more when I want to create an index for the view I get the error "Cannot add clustered index to views using OUTER JOINS".</p>
  
  <p>It's maddening, and ideas why this could be happening?</p>
  
  <p><img src="https://i.stack.imgur.com/DM7Zc.png" alt="enter image description here"></p>
  
  <p>So when I try to create an index for the view I get the message I used an outer join though I didn't.</p>
  
  <p><img src="https://i.stack.imgur.com/221aJ.png" alt="enter image description here"></p>