MYSQL【将查询的结果修改到另一个表中】

UPDATE sys_user_info_details_b a

    INNER JOIN (select group_concat(distinct sc.CODE_VALUE) as CERTIFICATE, ddbib.USER_ID

                 from sa_code sc

                          inner join dd_dict_bussiness_info_b ddbib

                                     on sc.code_no = 'BOURSE_TYPE' where sc.CODE_NAME = ddbib.CODE_NO and ddbib.STATUS = 'C' and

                                        ddbib.CODE_VALUE = '1'

                 group by ddbib.USER_ID) AS b

    SET a.CERTIFICATE = b.CERTIFICATE where a.ID = b.USER_ID;