I have 2 tables, item and item cost. They join on an item_urn field. Item is the master table of inventory. Item cost us a list of all of the past and current costs of the items so there is a 1 to many relationship of items to item_cost. The item cost table has a item_urn, an effective date and an amount. What I need to do is to get the amount associated with the latest effective date for each item_urn. This seems very simple but I can't seem to get it.