In the database, each item has many prices because the price data is stored since it been purchased. but in report i would like to take the latest data. For example:
Item Price(May'09) Price(Jun'09) Price(Jul'09) Price(Aug'09)
aa $1 $1.02 - $1.05
bb - $0.90 $0.95 -
So for each item i need to take the latest price. from table above;
item aa, the latest price is in Aug'09 which is $1.05,
while for item bb, the latest price is in Column July which is $0.95.