Problem with Left Join

https://laravel.com/docs/5.6/queries#joins

$result = Rest::leftJoin('bookings', 'rest_id', '=', 'id')->whereNull('rest_id')->get();

@Vilfago There is also whereNull method.

Try to set your relations, and then try that :

https://laravel.com/docs/5.6/eloquent-relationships#querying-relationship-absence

It will be far better than my tentative above.

Thanks @RoboRobok, updated.

Hello @Vilfago I tried your solution but not worked as you can see from my query i am trying to get unmatched records from Left Table (rests)

Did you try $result = App\Rest::doesntHave('bookings')->get();

no @Vilfago i used it now i got this error

BadMethodCallException: Call to undefined method Illuminate\Database\Query\Builder::bookings() in file C:\xampp\htdocs\weekend\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php on line 2483

You have to set the relation in your model before. https://laravel.com/docs/5.6/eloquent-relationships#introduction

It worked as next $un_booked_rests = DB::table('rests')->LeftJoin('bookings','rests.id' ,'=' ,'bookings.rest_id') ->select('rests.*') ->WhereNull('bookings.rest_id') ->get();