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