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
- Column 'is_valid' in where clause is ambiguous
- Column 'id' in where clause is ambiguous
- Column 'id' in where clause is ambiguous
- Column 'id' in where clause is ambiguous
- Column 'Email' in where clause is ambiguous
- Column 'id' in where clause is ambiguous
- Column 'id' in where clause is ambiguous
- Column ' ' in where clause is ambiguous
- column 'typeid' in where clause is ambiguous
- column in where clause is ambiguous MySQL异常
- 数据库异常:“Column 'CODE' in where clause is ambiguous”
- mysql Column 'dbvalue' in where clause is ambiguous解决方案
- 错误信息:Column 'SalesMarketID' in where clause is ambiguous
- mysql Error:1052 Column 'xxx' in where clause is ambiguous
- 错误代码: 1052 Column 'sys_date' in where clause is ambiguous
- where clause is ambiguous
- Integrity constraint violation: 1052 Column "order_id" in where clause is ambiguous
- Integrity constraint violation: 1052 Column 'status' in where clause is ambiguous
- 健康今日b
- UVA 140 带宽 Bandwidth (暴力枚举+剪枝)
- 健康今日c
- android studio连接不上手机的解决办法
- 健康今日d
- Column 'is_valid' in where clause is ambiguous
- 健康今日e
- IP黑名单校验
- 健康今日f
- 健康今日g
- android——闹铃不准的解决
- C# application 强命名 和 混淆
- Tomcat的安装配置与JavaWeb入门教程
- lambda函数初遇python