Mysql 查询 Operand should contain 1 column(s)

最新推荐文章于 2024-03-03 15:55:59 发布

weixin_45456834

最新推荐文章于 2024-03-03 15:55:59 发布

阅读量651

点赞数

本文链接：https://blog.csdn.net/weixin_45456834/article/details/121555613

版权

mysql

MySql查询Operand should contain 1 column(s)

SELECT
	basInfo.Initiator,
	basInfo.Initiation_time,
	basInfo.response_person,
	basInfo.start_plan_implement_time,
	basInfo.end_plan_implement_time,
	basInfo.task_content,
	basInfo.pk_work_basics_info,
	(
		SELECT
			min(tor.createTime),
			tor.executor
		FROM
			imp_work_executor_info AS tor
		WHERE
			tor.pk_work_basics_info = basInfo.pk_work_basics_info
		AND tor.dr = 0
		GROUP BY
			tor.createTime
	) AS executor,

FROM
	imp_work_basics_info AS basInfo
WHERE
	basInfo.dr = 0