Level 17
what about left join :
SELECT u.Id ... FROM users u LEFT JOIN employees e ON u.Id = e.user_id WHERE e.user_id IS NULL
Aug 12, 2020
3
Level 5
Query all records in table where there isn't a match in the other?
For a one-to-one relationship, how do you query only the records without a match? I see that in MySQL you can't use EXCEPT. I also tried looking at the various joins.
Users Table: id name
Employees Table: user_id
I only want the results from the users table that are not linked to the employees table.
Level 25
@ajsmith_codes if you are using Eloquent you can query for relationship absence with doesntHave method
https://laravel.com/docs/7.x/eloquent-relationships#querying-relationship-absence
Level 5
@programators That worked! Here is my final code:
$users = DB::table('users')
->leftJoin('employees', 'employees.user_id', '=', 'users.id')
->where('employees.user_id', '=', null)
->get();
Please or to participate in this conversation.