Hi All,
I have a simple select that uses outer join, however when i execute the statement it acts like inner join. Here is my statement.

SELECT dbo.Customers.CompanyName, dbo.Customers.ContactName, dbo.Customers.City, dbo.Orders.RequiredDate
FROM dbo.Orders LEFT OUTER JOIN
dbo.Customers ON dbo.Orders.CustomerID = dbo.Customers.CustomerID
WHERE (dbo.Customers.CustomerID = 'Zacha')

I want to pull all records from Orders table.. I have done this before, but can't figure out why it is not working here.

thanks