Part 37 INNER JOIN IN SQL
--select top 2 * from SalesLT.ProductCategory
--select top 2 * from SalesLT.Product
select p.ProductCategoryID,p.Name from SalesLT.ProductCategory pc join
SalesLT.Product p on pc.ProductCategoryID = p.ProductCategoryID
where pc.ProductCategoryID = 5
-- select distinct ProductCategoryID from SalesLT.Product
sql #sqlserver #sqltutorial #sqltutorialforbeginners