Ciao, che differenza c'è tra:

SELECT *
FROM dbo.Employees LEFT OUTER JOIN
dbo.Orders ON dbo.Employees.EmployeeID = dbo.Orders.OrderID

e la INNER JOIN???