I have a table with Inventory transacation records.
The table contains both Shipment (outgoing) and Receiving (incoming) transactions.
I'm trying to write a report that lists both Sales Orders that result in Shipment records and Purchase Orders that result in Receiving records.
If I link the Inventory Transaction table to the Shipment (Sales Order) tables and to the Receiving (Purchase Order) tables, I only get one or the other (Sales or Purchasing) records, not both. Is there a trick to this with Left, Inner and Right joins on the tables or do I need some other approach?
Thanks for the help,
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!