Home Forums Article Discussions Article Discussions by Author Discuss content posted by Prashant Pandey SQL - Derived Tables RE: SQL - Derived Tables
corey lawson
Hall of Fame
Points: 3773
More actions
January 16, 2008 at 12:18 am
#768477
"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
-- ...