构建查询，从多个表中提供计算结果

I need to build a query that contains a Fair market Value for each fund in a portfolio. These are not public entities, so the Fair market value statements don’t come every month. The calculation is simple when I step through a cursor based operation, but I would like to build a query that returns all of the results at once. Here’s a simplified version of how it works:I need to build a query that contains a Fair ma