Laravel Eloquent LEFT JOIN WHERE NULL

Question

I m trying to use Eloquent to perform the following query during a database seed   SELECT       FROM     customers LEFT JOIN     orders     ON customers id   orders customer id WHERE     orders customer id IS NULL   And here is my implementation in Eloquent    c   Customer  leftJoin  orders   function  join           join- gt on  customers id         orders customer id               - gt whereNull  orders customer id       - gt first      Whereas the first query always returns full results  the Eloquent equivalent always returns empty elements for everything but the email and phone fields of the customers table  I m at a loss to explain this since the Customers and Orders models are both artisan generated skeletons   Ex   class Customer extends  Eloquent           Add your validation rules here     public static  rules                 title    gt   required                 Don t forget to fill this array     protected  fillable            Here is the array that is output when I dd   the first Eloquent query on a seed  generated originally by Faker    protected  original   gt    array 25         id    gt      NULL      first name    gt      NULL      last name    gt      NULL      email    gt      string 24   luther braun example org       phone    gt      string 17   642 150 9176x5684       address1    gt      NULL      address2    gt      NULL      city    gt      NULL      state    gt      NULL      county    gt      NULL      district    gt      NULL      postal code    gt      NULL      country    gt      NULL      notes    gt      NULL      created at    gt      NULL      updated at    gt      NULL      customer id    gt      NULL      total    gt      NULL

User · Answer

Although Other Answers work well  i want to give you alternate short version which i use very often  Customer  select  customers             - gt leftJoin  orders    customers id         orders customer id           - gt whereNull  orders customer id  - gt first     And as in laravel version 5 3 added one more feature which will make your work even simpler look below for example  Customer  doesntHave  orders  - gt get

User · Answer

I would dump your query so you can take a look at the SQL that was actually executed and see how that differs from what you wrote   You should be able to do that with the following code    queries   DB  getQueryLog     last query   end  queries   var dump  last query   die      Hopefully that should give you enough information to allow you to figure out what s gone wrong

User · Answer

You can also specify the columns in a select like so    c   Customer  select      DB  raw  customers id AS id  customers first name AS first name  customers last name AS last name    - gt leftJoin  orders   function  join       join- gt on  customers id         orders customer id      - gt whereNull  orders customer id  - gt first

User · Answer

This can be resolved by specifying the specific column names desired from the specific table like so    c   Customer  leftJoin  orders   function  join           join- gt on  customers id         orders customer id               - gt whereNull  orders customer id       - gt first            customers id            customers first name            customers last name            customers email            customers phone            customers address1            customers address2            customers city            customers state            customers county            customers district            customers postal code            customers country

User · Answer

use Illuminate Database Eloquent Builder    query   Customers  with  orders     query    query- gt whereHas  orders   function  Builder  query  use   request          query    query- gt where  orders customer id    NULL             query    query- gt get

User · Answer

I would be using laravel whereDoesntHave to achieve this   Customer  whereDoesntHave  orders  - gt get

[php] Laravel Eloquent LEFT JOIN WHERE NULL

Examples related to php

Examples related to mysql

Examples related to laravel

Examples related to laravel-4

Examples related to eloquent