mos wrote:
The Details table has Product_Code: Char(20), Date_Sold: Date, and Price_Sold: Double. The products are sold for different prices during the month and I need to retrieve the last price it was sold for.
select product_code, price_sold, max(date_sold) from details group by product_code; Regards Gautam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
