laravel临时表查询

$dataTempQuery = $dispatchCostPay->groupBy('costs.ID')->union($orderCostPay->groupBy('costs.ID'));
$data = \DB::table(\DB::raw("({$dataTempQuery->toSql()}) as t"))->groupBy('ID')->skip($skip)->limit($pagesize)->get();

  

posted @ 2019-07-10 12:00  佚小名  阅读(1159)  评论(2)    收藏  举报