注册

无效的ORDER BY子句

ꪶꪮꪜꫀꪑꫀ 2021/09/17 1507 1

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:DM8 + idea
【CPU】:
【问题描述】*:第15 行附近出现错误[-4013]:
无效的ORDER BY子句(以前是MySQL写的,现在转换成DM)
sql语句:SELECT
a.id,
COALESCE ( sum( pt.complete_percent * pt.plan_working_hours ), 0 ) AS totalNowWorkingHours,
COALESCE ( sum( pt.plan_working_hours ), 0 ) AS totalPlanWorkingHours
FROM
pm_projectinfo a
LEFT JOIN pm_project_plan pt ON a.id = pt.project_id
AND pt.is_delete = ‘0’
AND pt.is_leaf_node = ‘1’
WHERE
a.id IN ( ‘823088040e4746b2a6605e309c8e8b7e’ )
GROUP BY
a.id
ORDER BY
a.update_date DESC

回答 0
暂无回答
扫一扫
联系客服