mercredi 19 décembre 2018

Query in Laravel5.7

have a problem to make a query in laravel

my query in POSTGRESQL is:

SELECT con.id, con.vehiculo_id, con.cre, ve.chofer_id
FROM conciliaciones as con 
JOIN vehiculos as ve
on con.vehiculo_id = ve.id or con.vehiculo_id IS NULL or con.vehiculo_id IS NOT NULL;

i have this code, but it does not work

     $conciliacion = DB::table('conciliaciones')
    ->join('vehiculos','conciliaciones.vehiculo_id','=','vehiculos.id')        
    ->whereNull('conciliaciones.vehiculo_id')
    ->whereNotNull('conciliaciones.vehiculo_id')
    ->get();

how i can make a query

In the query select other columns but is Similary that i need in laravel

thanks



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire