subqueries in laravel 5.4

Question

how can I make this query to query builder laravel 5.4?

select * from gb_employee where employee_id not in (select gb_emp_client_empid from gb_emp_client_lines where gb_emp_client_clientid =1) ;

Possible duplicate of [Laravel Eloquent with two “WHERE NOT IN” in subquery](https://stackoverflow.com/questions/44743083/laravel-eloquent-with-two-where-not-in-in-subquery) — Jerodev, Jun 20 '18 at 07:54

M Khalid Junaid · Answer 1 · 2018-06-20T08:35:31.317

Use a left join for this

$employee=DB::table('gb_employee as e')
                ->select('e.*')
                ->leftJoin('gb_emp_client_lines as el', 'e.employee_id', '=', 'el.gb_emp_client_empid')
                ->whereNull('el.gb_emp_client_empid',)
                ->get()
;

doing via eloquent way

class Employee extends Model
{

    public function client_lines()
    {
        return $this->hasMany('App\ClientLines', 'gb_emp_client_empid', 'employee_id');
    }
}

$employees = Employee::doesntHave('client_lines')->get();

score 0 · Accepted Answer · answered Jun 20 '18 at 08:10

I think I solved it. . .

$employees = DB::table('gb_employee')
                            ->whereNotIn('employee_id', function($query) use ($client_id)
                            {
                                $query->select('gb_emp_client_empid')
                                      ->from('gb_emp_client_lines')
                                      ->where('gb_emp_client_clientid',$client_id);
                            })
                            ->get();

subqueries in laravel 5.4

2 Answers2