Column 'is_valid' in where clause is ambiguous

最新推荐文章于 2024-07-16 19:27:49 发布

呆萌小吃货

最新推荐文章于 2024-07-16 19:27:49 发布

阅读量758

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/qq_29405421/article/details/54946171

版权

java 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

某列字段所属模糊不清

例子：

SELECT
a.class_id AS "classInfo.id",
ci.class_name AS "classInfo.className"
FROM class_student_info a
LEFT JOIN class_info ci ON a.class_id = ci.class_id
WHERE
is_valid=0 此处应说明该字段是哪张表的

and a.student_id = '1'

改为：

SELECT
a.class_id AS "classInfo.id",
ci.class_name AS "classInfo.className"
FROM class_student_info a
LEFT JOIN class_info ci ON a.class_id = ci.class_id
WHERE
a.is_valid=0
and a.student_id = '1'