>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.

Take a look at Thread #530650 Message #530682. It should give you an idea how it can be done.