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.
SELECT
S.companyname AS supplier, S.country,
P.productid, P.productname, P.unitprice
FROM Production.Suppliers AS S
LEFT JOIN Production.Products AS P
ON S.supplierid = P.supplierid
WHERE S.country = N'Japan';
The following query, which I thought should show me the same results as above does not. :(
SELECT
S.companyname AS supplier, S.country,
P.productid, P.productname, P.unitprice
FROM Production.Suppliers AS S
LEFT JOIN Production.Products AS P
ON S.supplierid = P.supplierid
and S.country = N'Japan';
can someone explain the behaviour, please?
Left Join
Posted - 02/08/2013 : 11:16:32
