How to join two tables with max value not greater than another value of column

view full story

http://serverfault.com – Apologies for the confusing question title, but I'm not exactly sure how to describe the issue at hand. I have two tables in Oracle 9i: Pricing ------- SKU ApplicableTime CostPerUnit Inventory --------- SKU LastUpdatedTime NumberOfUnits Pricing contains incremental updates to the costs of each particular SKU item, at a specific Unix time. For example, if I have records: SKU ApplicableTime CostPerUnit ------------------------------------ 12345 1000 1.00 12345 1500 1.50 , then item 12345 is $1.00 per unit for any time between 1000 and 1500, and $1.50 for (HowTos)