Eloquent
Hello, I'm new on Laravel, and I need some help to build this query. My clients have many contacts, I want to get all clients, but only return the contact marked as main. It´s possible with Eloquent, or I need to use Query. Please if is possible to put a example.
Last updated
3 years ago.
$clients = Client::leftJoin('contacts', function($join) {
$join->on('client.id', '=', 'contacts.client_id');
})
->where('contacts.type','=','main')
->get();
maybe something like this?
Last updated
10 years ago.
Solution
Perfectly, thanks for your help!!! Now I understand the concept. Sorry my bad english :)
Sign in to participate in this thread!
Laravel
Laravel News
Laracasts
Laravel Podcast