Showing posts with label full join in sql. Show all posts
Showing posts with label full join in sql. Show all posts

Saturday, 14 May 2016

How to full join in sql

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