8 Replies Latest reply: Jul 4, 2016 3:00 AM by fredrik olsson RSS

    Inner join between dates

    fredrik olsson

      Hi,

       

      I'm trying to concatenate two tables when the dates conditions are met in the WHERE clause.

      Everything works as it should except when OrderDate and the ToDate are the same date.

       

      Any help would be much appreciated?!

       

      WHERE OrderDate >= FromDate and OrderDate <= ToDate;


      Order:

      OrderIdTotalOrderDate
      12343302016-01-02
      1235105

      2016-01-15

       

      Markup:

      CategoryCodeDescrCountryCodePriceFromDateToDate
      GENERALALLText1 - internalSE172016-01-012016-01-02