Column 'is_valid' in where clause is ambiguous

来源:互联网 发布:沥青针入度试验数据 编辑:程序博客网 时间:2024/06/05 02:35

某列 字段 所属模糊不清

例子:

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'

0 0
原创粉丝点击