SELECT opt tlabel_id tlabel_name FROM oss_push_trump optLEFT JOIN SELECT GROUP_CONCATlabel_id AS label_id GROUP_CONCATlabel_name AS label_name FROM uc_user
如果SELECT push_label_id FROM oss_push_trump返回多条数据,您可以使用IN关键字来替换FIND_IN_SET函数。以下是修改后的查询语句:
SELECT opt.*, t.label_id, t.label_name FROM oss_push_trump opt LEFT JOIN ( SELECT GROUP_CONCAT(label_id) AS label_id, GROUP_CONCAT(label_name) AS label_name FROM uc_user_label WHERE uc_user_label.label_id IN (SELECT push_label_id FROM oss_push_trump) ) t ON opt.push_label_id = t.label_id
原文地址: https://www.cveoy.top/t/topic/hAWN 著作权归作者所有。请勿转载和采集!