3 Replies Latest reply: May 25, 2017 3:59 AM by Enrique Gutierrez RSS

    Filter data according to other table in database

    Mandi Hu

      Hi all,

       

      I have a question about loading data. Suppose I have two tables.These two tables are related by a column named 'ItemID'. Table A is the main table and has all data. Table B has a list of data 'ItemID' that I want to modify. How can I change values in other columns in Table A when the ItemID is included in Table B.

       

      Thank you,

      Mandi