我试图在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 .
版权声明：本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
你可以试试：
$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
