2 Replies Latest reply: Sep 23, 2009 2:54 PM by mgobbi RSS

    Updating field data using left join

    mgobbi

       

      Have a scenario where a field has to be created based on a general part basis and then that field needs to be updated based on a more specific basis. Thought that the process could be done using left joins as follows but that is not the case. Have a workaround, but wondering if there is another way along these lines. Thanks.

       

       

      //add the class by part (General)

      LEFT JOIN (KeyLink)

      LOAD

      GGPN AS Part,

      GCLASS AS Class

      RESIDENT ClassGeneral;

       

      // add the class by parent number & part number (Specific)

      LEFT JOIN (KeyLink)

      LOAD

      ClassKey AS Key2,

      SCLASS AS Class

      RESIDENT ClassSpecific;