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.