I am having problems writing a query.

My query is

But I only want to pull in the latest PRICE_PER_UNIT. I know I need to do a subquery and return the max PRICE_EFF_DATE but I can't figure out how to do it. Can somebody please help me?

Try This Out

Select
V_mstr_po.cust_part,
V_mstr_po_part_price.price_per_unit,
V_mstr_po_part_price.price_eff_date,
V_mstr_po.curr_code,
V_mstr_po.mult_rate_func
From
V_mstr_po,
V_mstr_po_part_price
Where
V_mstr_po_part_price.key_id = V_mstr_po.key_id
And
V_mstr_po_part_price.price_eff_date = (select Max(price_eff_date) From V_mstr_po_part_price);



I Dint Try It Out....
Pls Let If It Worked Or Not ....