5 Replies Latest reply: Apr 24, 2013 10:36 AM by sree anaarasi RSS

    Load From one table by values from another

    Travis Russo

      Hello all,

       

      Let's say I have these 2 tables I'm loading from. Table 1 contains sales orders, and Table 2 contains item information.

       

      Table 1 has an order with Items 123, 234, and 456. Table 2 has those items but a bunch more as well. The goal would be to load ALL records from Table 1, and only load the records from Table 2 where those item numbers match the sales orders from Table 1.

       

      This is probably relatively easy to do but I can't seem to get it working right.

       

      Thank you!