Query Builder and find records from one table which don't exist in another using laravel

Question

I am using Laravel 5 and its Query Builder to retrieve data from database. I want to take following output.

I want to take this question thinks using Query Builder

Now I try this code, but not successfully:

$all_members = CommiteeMember::join('members', 'commiteeMembers.memberId', '<>', 'members.id')
->where('commiteeId', $commitee->id)->get();

In what way did this code not succeed? What are you trying to do? — halfer, Sep 16 '15 at 10:28
this code out put is not correct. it give all details. :-( but i want to do above link things. — uma, Sep 16 '15 at 11:36
@uma you will have to use either left or right join as per your table requirement. — Deepanshu Goyal, Sep 18 '15 at 10:39

score 0 · Answer 1 · answered Sep 16 '15 at 11:57

0

I don't know what are you trying to achieve.

But from your title looks like what you need is left join.

 $all_members = CommiteeMember::leftJoin('members', 'commiteeMembers.memberId', '<>', 'members.id')
->where('commiteeId', $commitee->id)->get();

answered Sep 16 '15 at 11:57

ssuhat

Thank you.....! @sstarlight i try this. really i want build quarry to take result like this question. deference ,I use laravel quary builder. http://stackoverflow.com/questions/367863/sql-find-records-from-one-table-which-dont-exist-in-another – uma Sep 16 '15 at 13:16

1 Answers1