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