SELECT
gpt.province_id AS provinceid ,
gpc.id AS ProNameid,
'' provincepeoplename,
SUM(gpt.amount) AS amount,
SUM(gpt.weight) AS weight,
SUM(gpt.area) AS AREA,
SUM(ctd.weight) AS cirweight
FROM qy_goal_company_task gct
INNER JOIN qy_goal_province_task gpt ON gpt.company_task_id=gct.id
INNER JOIN qy_goal_area_task gat ON gat.company_task_id=gpt.company_task_id
INNER JOIN qy_goal_salesman_task gst ON gst.area_task_id=gat.id
INNER JOIN qy_goal_client_task_detail ctd ON ctd.company_task_id=gct.id
INNER JOIN qy_goal_prod_config gpc ON gpc.id=ctd.prod_id
INNER JOIN qy_goal_prod_series_config psc ON psc.id=gpc.prod_series_id
INNER JOIN qy_goal_prod_classify_config pcc ON pcc.id=psc.prod_type_id
INNER JOIN qy_goal_sale_cycle_config scc ON scc.id=gpc.cycle_id
INNER JOIN qy_goal_province_config gpcg ON gpt.province_id=gpcg.id
WHERE
scc.id=169
AND pcc.id=1
AND psc.id=1
AND gpc.id=1
AND gpt.province_id=1
and ctd.clent_id IN (SELECT ReceiverID FROM salermoney_platform_detail GROUP BY ReceiverID )
GROUP BY
gpt.province_id,
gpc.id
> 1054 - Unknown column 'ctd.clent_id' in 'IN/ALL/ANY subquery'
> 时间: 0s
这段where条件里为什么不让写查询条件呀
mysql where子句中不允许带查询的列吗?
最新推荐文章于 2024-09-15 20:24:46 发布