Hi,Hope someone can help me. Should be straight forward. I am having a hard time understanding this:The following query returns the right results as expected.SELECTS.companyname AS supplier, S.country,P.productid, P.productname, P.unitpriceFROM Production.Suppliers AS SLEFT JOIN Production.Products AS PON S.supplierid = P.supplieridWHERE S.country = N'Japan';
The following query, which I thought should show me the same results as above does not. :(SELECTS.companyname AS supplier, S.country,P.productid, P.productname, P.unitpriceFROM Production.Suppliers AS SLEFT JOIN Production.Products AS PON S.supplierid = P.supplieridand S.country = N'Japan';
can someone explain the behaviour, please?