MySQL 两条语句的合并查询问题

// 查询一
$sql = "SELECT sum(`real_price`) total_real_price FROM `order` WHERE `wid` = 200 AND `type` = 2 AND `is_pay` = '1' AND `deleted_at` IS NULL";
$result_real = $this->model->dbconfig('aa')->query($sql)->find();

// 查询二
$sql = "SELECT sum(`balance_price`) total_balance_price FROM `order` WHERE `wid` = 200 AND `type` = 3 AND `is_pay` = '1' AND `deleted_at` IS NULL";
$result_balance_price = $this->model->dbconfig('aa')->query($sql)->find();

如何将这样的语句合并成一条语句查询呢?

阅读 1k
撰写回答
你尚未登录,登录后可以
  • 和开发者交流问题的细节
  • 关注并接收问题和回答的更新提醒
  • 参与内容的编辑和改进,让解决方法与时俱进
推荐问题