Mybatis - Column 'status' in where clause is ambiguous

查询数据的时候提示错误:

Column 'CREATE_TIME' in where clause is ambiguous  

错误原因:查询语句是对多表数据联合查询,其它表中有相同字段!

解决方法:在出错字段前面加上表的别名即可!

参考:

https://blog.csdn.net/iteye_8971/article/details/82651196

posted on 2020-08-12 15:27  sunylat  阅读(804)  评论(0编辑  收藏  举报