当前位置: 首页>后端>正文

EasySwoole join with 组合使用 sql 错误处理

easyswoole框架版本号

"easyswoole/easyswoole": "3.5.x",
"easyswoole/orm": "^1.5"

问题描述

Column ‘id’ in field list is ambiguous
easyswoole关联查询失败、easyswoole with查询失败、easyswoole orm 关联查询

EasySwoole 多表联查sql出现异常,提示:Column ‘id’ in field list is ambiguous,明明指定了字段还是会拼接出 id。

Column 'id' in field list is ambiguous

解决方案

查时候一定要 alias 重命名主表
$orderModel->alias(“orders”);

 $orderModel = new TestOrder();
 $orderModel->alias("orders"); ## 这行一定要有!!!!
 $orderModel->with(["orderLog", "orderGoods"]);
 $orderModel->join("fa_test_order_goods as order_goods", "order_goods.order_id = orders.id");

相似问题:github issues


https://www.xamrdz.com/backend/3qn1848755.html

相关文章: