strange group/max date question...

[bruce]

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