Hi , In this blog post will check the join queries SQL Join function below diagram shows difference possibilities Below queries has been executed on the video podcast -- will see about join query from the db table schema diagram -- will check about product and transaction history table on join query select * from Production.Product -- 504 records select * from Production.TransactionHistory -- 113443 records -- inner join select * from Production.Product p inner join Production.TransactionHistory t on p.ProductID = t.ProductID -- full join or full outer join select * from Production.Product p full outer join Production.TransactionHistory t on p.ProductID = t.ProductID -- right join or right outer join select * from Production.Product p right outer join Production.TransactionHistory t on p.ProductID = t.ProductID -- left join or left outer join select * from Production.Product p left outer join Production.TransactionHistory t on p.ProductID = t.Product...