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

    Updating field data using left join



      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)


      GGPN AS Part,

      GCLASS AS Class

      RESIDENT ClassGeneral;


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

      LEFT JOIN (KeyLink)


      ClassKey AS Key2,

      SCLASS AS Class

      RESIDENT ClassSpecific;