5 Replies Latest reply: Jun 24, 2013 3:42 PM by Raj Vadde RSS

    Scripting: Left join with criteria

    Steve Zagzebski

      I need to left join to a table and only show the records from the Product table that meet the criteria:

       

      Active_Date >= Effective_Date and Active_Date<Term_Date

       

      I am struggling with the getting the proper code/syntax

       

      Example code withouth the above crtieria:

       

      Table_1:

      Load

      Product ,

      Active_Date

      Resident Table;

       

      Left Join (Table_1)

       

      Load

      Product,

      Type_Flag,

      Effective_Date,

      Term_Date

      Resident Product;