I found the solution thanks
return View::make('contato.email')
->with('emails', ContatoEmails::select(array('contato.id as idContato', 'contato.nome as nomeContato', 'contato.email', DB::Raw('group_concat(lista.nome) as nomeLista')))
->leftjoin('contatosLista', 'contato.id', '=', 'contatosLista.idcontato')
->leftjoin('lista', 'contatosLista.idlista', '=', 'lista.id')
->groupBy('contato.id')
->orderby('idContato')
->paginate(10));
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community