Query that inherits twice from a table

Question

Query that inherits twice from a table

Navigation

#1 by (0 votes)

0

Select
    v.id_user, 
    uv.nombre_nacion as PaisEnvia,
    up.nombre_nacion as PaisRecibe
From 
 solicituds as v
 INNER JOIN pais as uv on v.id_pais_envia = uv.id_nacion
 INNER JOIN pais as up on v.id_pais_recibe =up.id_nacion;

It would be that same but in Eloquent

mysql php laravel

asked by maykel trejo 17.12.2018 в 15:27

source

1 answer

Share user variable with all components in Angular Angular Autocomplete, autocomplete is not performed correctly when adding more elements

score 0 · Accepted Answer

I already achieved this code

$pedido=DB::table('solicituds as v')
                   ->select(
                          'v.id_user',
                          'v.id_pais_envia',
                          'v.id_pais_recibe',
                          'av.nombre_nacion as PaisEnvia,',
                          'ap.nombre_nacion as PaisRecibe'
                          )
                    ->join('pais as av','av.id_nacion','=','v.id_pais_envia')
                    ->join('pais as ap','ap.id_nacion','=','v.id_pais_recibe')
                    ->get();