hi for all i write this sql statment: SELECT HidenNum, action, msgid FROM MsgTrans AS MsgTrans1 WHERE (HidenNum IN (SELECT MAX(HidenNum) AS Expr1 FROM MsgTrans ...