订购UNION查询:


ordering UNION queries laravel 5

我有两个表,每个表包含created_at时间戳列,在它们之间进行联合后,我试图通过联合后进行排序,但它不工作,所以我如何根据Laravel中两个表的created_at列排序数据降序?

$vac = db::table("table_a")->select($arr);
    $m = db::table("table_b")->select($arr_1)->union($vac)->get();

in controller

use DB; 

in inside controller function

DB::select('select ? from table_a union  select ? from table_b order_by created_at desc',[$arr,$arr_1]);