hi... i have the following select... select itemID, process, status, tblType, max(date) from historyTBL where (tblType = '3' or tblType = '2') group by tblType;
it seems to work, in that it gives me the rows for the two types that i'm grouping by. the problem is that i want the row that contains the max date. the query is only returning the max date, with the other elements in the row coming from who knows where in the table. any idea on how i can achieve the complete row containing the max date??? i've looked through google/mysql with no luck.... thanks. -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
