Forgive me, but my SQL is pretty weak. I have two tables, one containing static inventory information, the other containing a history of the dynamic status information for the inventory. I need a view (or at least a SQL statement) that will join the two, attaching only the most recent dynamic info for each piece of inventory.