SQL Server replaces LEFT JOIN for LEFT OUTER JOIN in view query

Question

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.

When trying to use LEFT INNER JOIN I get the error "Incorrect syntax near word 'INNER'". ideas why this could be happening?

Answer 1

there are different ways of writing joins. you're looking for is a LEFT OUTER JOIN. There is no LEFT INNER JOIN.