我试图在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