Saturday 14 May 2016

How to left join in sql

SELECT Client.ClientName, Product.ProductID
FROM Client
LEFT JOIN Product
ON Client.ClientID=Product.ClientID
ORDER BY Client.ClientName;