Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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