1 Reply Latest reply: Sep 30, 2010 7:52 AM by Miguel Angel Baeyens de Arce RSS

    JOIN on intervals

    fabianomartinothera

      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