How can I JOIN two tables based on an interval?
I have an ORDER which goes from 03/05/2009 to 13/06/2009 (european format).
How can I join the orders to a table which holds the PROMOTIONS, where I have a promotion which is valid from 01/05/2009 to 15/06/2009?
I'd use intervalmatch following this example.
Hope that helps.
Retrieving data ...