"Theta Joins" also can be used.

For the given example in the article, the results should match for this query:

select c.*, o.*

from customers as c

left join orders as o

on c.customerid = o.customerid and year(o.orderdate) = 1996

--where

-- ...