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 '12 at 12:25 PM in Default
answered Jul 19 '12 at 12:32 PM