Inner Joins - take 2 data sources and return all matching pairs of rows based on the join condition. unmatched rows are discarded

inner_join.sql

--ansi sql-92 standard syntax (filter rows in the ON clause)

SELECT
  p.Name,
  od.ProductId,
  od.SalesOrderDetailId,
  od.OrderQty
  
FROM 
  Production.Product AS p
  
  INNER JOIN Sales.SalesOrderDetail AS od
  ON p.ProductId = od.ProductId

ORDER BY
  p.Name, od.SalesOrderDetailId;