|
1
2
3
4
5
6
|
$userId = 5;
$query = Products::SELECT('products.id','products.name','dealers.name')
->leftjoin('dealers', function($query) use($userId){
$query->on(DB::raw('(dealers.id '), DB::raw('"'.$userId.'")'));
})
->get();
|
More from my site
-
Join or Left Join only with where condition in laravel
-
Left join with last record of right table in Laravel & Mysql
-
How to change message languages dynamically in Laravel | Change localisation in Laravel
-
if else and case when in Laravel query
-
Laravel folder permissions
-
Dynamic database connection in Laravel 5.5 | Multiple database connection in Laravel 5.5 | MySQL & Redis database connection in Laravel | Change database or schema dynamically in a connection