将这条SQL语句进行优化SELECT NAMEFROM PFQA_EVALUATION_MANAGE_TOOL pemt WHERE CODE IN SELECT TOOL_CODE FROM PFQA_ACTIVITY_TOOL pat WHERE ACTIVITY_ID = 123

• 日期: 2026-07-22
• 标签: 社会

优化后的SQL语句:

SELECT pemt.NAME FROM PFQA_EVALUATION_MANAGE_TOOL pemt INNER JOIN PFQA_ACTIVITY_TOOL pat ON pemt.CODE = pat.TOOL_CODE WHERE pat.ACTIVITY_ID = '123'

原文地址: http://www.cveoy.top/t/topic/htho 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录