JOIN on intervals

[#1]

How can I JOIN two tables based on an interval?

e.g.

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?

Thanks

[Miguel_Angel_Baeyens]

Hello Fabianoo

I'd use intervalmatch following this example.

Hope that helps.