--INNER JOIN
SELECT p.Name AS ProductName, P.ProductID, S.Unitprice
FROM [Production].[Product] AS P
INNER JOIN [Sales].[SalesOrderDetail] AS S
ON P.ProductID = S.ProductID 

SELECT p.Name AS ProductName, P.ProductID, S.Unitprice
FROM [Production].[Product] AS P
JOIN [Sales].[SalesOrderDetail] AS S
ON P.ProductID = S.ProductID 

--LEFT JOIN

SELECT p.Name AS ProductName, P.ProductID, S.Unitprice
FROM [Production].[Product] AS P
LEFT JOIN [Sales].[SalesOrderDetail] AS S
ON P.ProductID = S.ProductID 

--RIGHT JOIN
SELECT *
FROM [Production].[ProductReview]


SELECT Comments, P.ProductID, Name AS ProductName
FROM [Production].[ProductReview] R
RIGHT JOIN [Production].[Product] P
ON R.ProductID = P.ProductID
ORDER BY Comments DESC

--FULL JOIN 
SELECT Jobtitle, FirstName, LastName
FROM HumanResources.Employee AS E
FULL JOIN Person.Person AS P
ON E.BusinessEntityID = P.BusinessEntityID






