有两个模型类
一个是订单 模型类名Order
一个是分销订单 模型类名Order
两个做一对一关联
做查询的时候发现,生成的sql语句的别名是一样的
请问, 怎么设置模型关联查询时候的别名呢?
生成的sql语句如下
SELECT COUNT(*) AS think_count FROM `kmdshop_agent_order` `Order` INNER JOIN `kmdshop_order` `Order` ON `Order`.`order_id`=`Order`.`order_id` WHERE `Order`.`app_id` = :ThinkBind_1_951898446_ AND `Order`.`order_status` = :ThinkBind_2_1637104307_ AND `Order`.`pay_status` = :ThinkBind_3_1711271297_ AND `is_delete` = :ThinkBind_4_534056202_ AND `create_time` BETWEEN :ThinkBind_5_786701312_ AND :ThinkBind_6_479468196_ AND `is_settled` = :ThinkBind_7_1002184045_
最佳答案
