Assuming you mean to get the latest pricing information for each asset based

on the latest primary key in Pricing, then it will look like this:

-- SQL Server 2000

SELECT A.asset_name,

P.phdate,

P.price

FROM Asset...