开发者社区 问答 正文

Laravel自连接查询

已解决

我试图在Laravel中执行自我联接查询。我正在尝试执行与原始查询相同的内容

$data['d_meetings'] =DB::select("select t1.,t2. from leads_followup_details as t1 inner join leads_followup_details as t2 on t1.leads_enquiry_details_enquiry_id = t2.leads_enquiry_details_enquiry_id inner join leads_enquiry_details on enquiry_id = t1.leads_enquiry_details_enquiry_id where t1.followup_meeting = 'direct' and t1.followup_id<t2.followup_id and t1.followup_next_followup_date=t2.followup_date and t2.followup_current_meeting = 'direct' and enquiry_deleted = 1 group by t1.followup_id");

$data['d_meetings'] = DB::table('leads_followup_details as t1') ->join('leads_followup_details as t2', 't1.leads_enquiry_details_enquiry_id', 't2.leads_enquiry_details_enquiry_id') ->where('t2.followup_id', '>', 't1.followup_id') ->where('t2.followup_id', '!=', 't1.followup_id') ->whereDate('t1.followup_next_followup_date', '=', 't2.followup_date') ->where('t1.followup_meeting', 'direct') ->join('leads_enquiry_details', 'enquiry_id', 't1.leads_enquiry_details_enquiry_id')->where('enquiry_deleted', 1) ->groupBy('t1.followup_id')->get();

but this is not working as my expectation .

展开
收起
保持可爱mmm 2019-12-18 17:00:19 1095 分享 版权
1 条回答
写回答
取消 提交回答
  • 采纳回答

    你可以试试:

    $data['d_meetings'] = DB::table('leads_followup_details as t1') ->select('t1.followup_id', 't2.followup_id', 't1.followup_next_followup_date', 't2.followup_date', 't2.followup_current_meeting', 't1.followup_meeting') ->join('leads_followup_details as t2','t1.leads_enquiry_details_enquiry_id','t2.leads_enquiry_details_enquiry_id') ->join('leads_enquiry_details','enquiry_id','t1.leads_enquiry_details_enquiry_id')
    ->where('t1.followup_id','<','t2.followup_id') ->where('t1.followup_id','<>','t2.followup_id') ->where('t1.followup_next_followup_date','=','t2.followup_date') ->where('t1.followup_meeting', 'direct') ->where('t2.followup_current_meeting', 'direct') ->where('enquiry_deleted',1) ->groupBy('t1.followup_id')->get();

    问题来源于stack overflow

    2019-12-18 17:00:40
    赞同 展开评论
问答分类:
PHP
问答地址: