Showing posts with label left join. Show all posts
Showing posts with label left join. Show all posts

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;