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