I have two tables, they are order by autonum so thats not a problem. First table contains products list, second table contains Price history of that product.

What I need is an INNER JOIN that will return the last record in the Price history table for a specific ID in the primary table.

Anyone know how to do this?