0 Replies Latest reply: Mar 2, 2017 8:56 AM by Philippe BALADIN RSS

    not included between the Start_date and the End_date of the table

    Philippe BALADIN

      Who would know the query to load data not included between 2 fields? let me explain :
      I have a data table (1) with a date field (ticket_date) on each line.
      And another table (2) with 2 fields dates to each line: Start_Date and End_Date

      I want the data load to take only those rows in the table (1) whose ticket_date field is not included between the Start_date and the End_date of the table (2).
      If you have a track I am taker.
      Thank you