table master has alast_dat, a date that is not updated. pk is reg_id. table detail has date_update, inserting each transaction. fk is reg_id.
is there an update command that will take max date from detail table and update alast_dat?
tia, .V -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]