Forum get only specified columns from the join table

posted 8 years ago

Database Eloquent

Last updated 2 years ago.

replied 8 years ago

i dont think with() does a join. it makes two queries ? try this

$users = User::join('user_details', 'user.user_id', '=', 'user_details.user_id')->select('users.user_id', 'users_details.phone')->get();

Last updated 8 years ago.

electricfan electricfan Joined 10 Apr 2015

We'd like to thank these amazing companies for supporting us

The Laravel portal for problem solving, knowledge sharing and community building.

Laravel.io

Socials

The community