5 Replies Latest reply: Apr 24, 2013 10:36 AM by Sree Anarasi RSS

    Load From one table by values from another

      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!