oracle改造mysql关于GROUP_CONCAT

select
   a.SPACE_SID AS space_sid,
   b.SPACE_DASH_FULL_NAME AS space_dash_full_name,
   (
   SELECT GROUP_CONCAT(O.ORG_FULL_NAME) FROM SRP_OM_ORGNIZATION O, SRP_SK_RS_R2_UNIT S
   WHERE O.SID = S.ORG_SID AND S.RISK_SID = a.SID
   ) ORG_FULL_NAME,
   a.SID AS risk_sid,
   a.VERSION AS risk_version,
   a.RISK_ID AS risk_id,
   a.EQUIPMENT_NAME AS equipment_name,
   a.RISK_CONTROL_URL AS risk_control_url,
   a.PICTURE_URD AS picture_urd
FROM srp_sk_rs_point a
LEFT JOIN srp_sk_om_space b ON a.SPACE_SID = b.SID