UPDATE NOTIFY as n,app_log as a SET n.READERS=(select group_concat(USER_ID) from app_log WHERE MODULE=4 and OPP_ID=n.NOTIFY_ID ) ;