left join in laravel return null if data exist in database

Question

I'm trying to left join two tables in laravel. after joining got all second table value is empty but data exist in a database .

sorry, bro, i am new for a stack . so I don't know how to share table structures — Saran
– Saran, Commented Mar 23, 2017 at 5:39
What about the other table? BTW you duplicated your join statement. — Taha Paksu
– Taha Paksu, Commented Mar 23, 2017 at 5:44

Taha Paksu · Accepted Answer · 2017-03-23 05:47:16Z

1

Can you try this:

$contacts = DB::table('C_Contacts')
        ->leftJoin('C_Contact_Category_Map', 'C_Contacts.contact_id', '=', 'C_Contact_Category_Map.contact_id')
        ->get();

answered Mar 23, 2017 at 5:47

Taha Paksu

15.6k2 gold badges50 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Saran Over a year ago

i got same result bro

Taha Paksu Over a year ago

Then check your database because it might really be empty or you are joining the wrong table, or you might not be saving the contact_id's on the category map table etc.

Tarang M Patel · Accepted Answer · 2017-03-23 07:17:54Z

0

Can You try this

$contacts = DB::table('C_Contacts')
    ->join('C_Contact_Category_Map', 'C_Contacts.contact_id', '=', 'C_Contact_Category_Map.contact_id')
    ->get();

answered Mar 23, 2017 at 7:17

Tarang M Patel

216 bronze badges

1 Comment

Tarang M Patel Over a year ago

Please check comment - i just replace leftjoin to join

Collectives™ on Stack Overflow

left join in laravel return null if data exist in database

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related