为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8
【操作系统】:
【CPU】:
【问题描述】*:SELECT
t.user_id,
t.emp_id,
t.emp_name,
t.org_id,
t2.label_name,
listagg( label_value,',') AS label_value FROM
t_label_biz_info t1
INNER JOIN t_label_info t2
INNER JOIN org_employee t ON t1.label_id = t2.id
AND t.emp_id = t1.biz_id
AND t1.biz_type = 2
and IF(IFNULL(?,'') !='', (t.emp_name LIKE CONCAT('%',?,'%') or t.user_id LIKE CONCAT('%',?,'%')), 1=1 ) AND t2.label_name = ? and IF(IFNULL(?,'') !='', t2.label_value = ?, 1=1 ) AND t1.tenant_id = ? GROUP BY t.emp_id limit ? 提示Caused by: dm.jdbc.driver.DMException: 第 13 行, 第 314 列[GROUP]附近出现错误:
语法分析出错
这样写呢 应该是 join 后没有 on 连接条件导致的错误 SELECT t.user_id,
t.emp_id,
t.emp_name,
t.org_id,
t2.label_name,
listagg( label_value,',') AS label_value
FROM t_label_biz_info t1
INNER JOIN t_label_info t2 ON t1.label_id = t2.id
INNER JOIN org_employee t
on t.emp_id = t1.biz_id
AND t1.biz_type = 2
and IF(IFNULL(?,'') !='', (t.emp_name LIKE CONCAT('%',?,'%')
or t.user_id LIKE CONCAT('%',?,'%')), 1=1 )
AND t2.label_name = ?
and IF(IFNULL(?,'') !='', t2.label_value = ?, 1=1 )
AND t1.tenant_id = ?
GROUP BY t.emp_id limit ?
能提供下相关表定义及SQL吗?方便测试。把值中的?修改成具体值呢