首页 > 解决方案 > laravel 同一张桌子上的联合不起作用

问题描述

public function getLatestList(){

$paginate = 10;

$data1 = DB::table('research_management')

->join('client','client.id','=','research_management.industry')

->select('research_management.*','client.image_link as image_link')

->where('delete_status','!=',2)

->orderBy('id','desc');

$data = DB::table('research_management1')

->join('client','client.id','=','research_management1.industry')

->select('research_management1.*','client.image_link as image_link')

->where('delete_status','!=',2)

->union($data1)

->orderBy('id','desc')->paginate($paginate);

return $data;

}

union not working 显示此代码的错误

标签: laravelunion

解决方案


推荐阅读