i have two tables 1. Product and 2.Product_Price
The tables have below columns 1.Product(ID PK,Product) 2.Product_Price(ID FK,Price,date)
the two ID is relationship.
i need the query for latest price and product name.
asked Jul 19, 2012 at 12:25 PM in Default
answered Jul 19, 2012 at 12:32 PM