Equi vs Non-Equi Join

equi_vs_non-equi.sql

SELECT 
  sod.SalesOrderId,
  sod.SalesOrderDetailId,
  sod.ProductId,
  sod.OrderQty,
  so.SpecialOfferId,
  sod.ModifiedDate,
  so.StartDate,
  so.EndDate,
  so.Description

FROM
  Sales.SalesOrderDetail AS sod
  
  INNER JOIN
    Sales.SpecialOffer AS so
  ON
    so.SpecialOfferId = sod.SpecialOfferId
  AND
    sod.ModifiedDate < so.EndDate
  AND
    sod.ModifiedDate >= so.StartDate

WHERE
  so.SpecialOfferId > 1;