laravel raw query on joins table code example
Example 1: laravel not in query
DB::table(..)->select(..)->whereNotIn('book_price', [100,200])->get();
Example 2: join in laravel eloquent
$customer = DB::table('customers')
->join('shops', 'customers.shop_id', '=', 'shops.shop_id')
->where('customer_contact', $contact_no)
->get();
Example 3: laravel find query
use App\Models\Destination;
use App\Models\Flight;
return Destination::addSelect(['last_flight' => Flight::select('name')
->whereColumn('destination_id', 'destinations.id')
->orderBy('arrived_at', 'desc')
->limit(1)
])->get();
Example 4: DB::table('users')->get();
DB::select('select * from users ');