7 Replies Latest reply: Jul 26, 2016 3:57 PM by Chris Neumann RSS

    Condition for Where Statement - Between Dates

    Chris Neumann

      Hi Guys

       

      Need a script for the following:

       

      Need to pull all data in Table 2 where Date A (in Table 1) is between Start and End Date in Table 2.

      Joining on Key

       

      Any assistance will be appreciated:

       

      Table1:
      LOAD [Employee],
           [Key],
           [Record Number],
           [Date A],
      [Status]                                                            

       

      FROM
      [..\.qvd]
      (
      qvd)

      ;

      Table2:
      LOAD [Key],
      [Structure Entity],
      [Start Date],
      [End date],
      Region,
      Division,
           Plant
      FROM
      [..\QVData\.qvd]
      (
      qvd)

      Where ([Date A] >= [Start Date] and  [Date A] <= [End date])

      ;