为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:
原始SQL :
SELECT
array_to_string(
ARRAY (
SELECT DISTINCT UNNEST
( string_to_array( string_agg ( concat_ws ( ',', pro.plan_cert_id, mods.cert_id ), ',' ), ',' ) )
),
','
) AS certIds,
array_to_string(
ARRAY (
SELECT DISTINCT UNNEST
( string_to_array( string_agg ( concat_ws ( ',', pro.ID, mods.ID ), ',' ), ',' ) )
),
','
) AS sourceIds
FROM
t_face_project pro
LEFT JOIN t_face_project_module mods ON pro.ID = mods.project_id
想要的结果: