This feels like a n00b question...
I'm writing a report in SQL. What is the best JOIN clause from the inventory transaction history (INVENTORY_TRANSACTION_HIST) to the customer order invoices (CUSTOMER_ORDER_INV_JOIN)?
I want to see the inventory transaction history so I can see all the cost elements on an invoiced order line.
I need a solution capable of handling multiple deliveries on the same line. The closest I've gotten so far is to use the proximity of the invoice and delivery dates, but that doesn’t feel completely right.
I don't think I need to handle credits (yet).
Best answer by duretteView original