php - How to make multiple subquery in Laravel 6?
one text
Solution:
You could make use of the function
$query = trim($request->get('searchText'));
$titulos = DB::table('titulo as t')
->select('t.nombre','t.anio')
->selectSub(function ($query) {
$query->from('Valor')
->whereColumn('Valor.id', 'titulo.tipo')
->select('Valor.value')
->latest()
->take(1);
}, 'tipo')
->selectSub(function ($query) {
$query->from('Valor')
->whereColumn('Valor.id', 'titulo.centro')
->select('Valor.value')
->latest()
->take(1);
}, 'centro')
->paginate(7);
Source