two table column display in single query Laravel 8 | nested query in Laravel

Joins in Laravel Inner Join Clause The query builder may also be used to add join clauses to your queries. To perform a basic “inner join”, you may use the join method on a query builder instance. The first argument passed to the join method is the name of the table you need to join to, while the remaining […]

Occasionally you may need to specify a route parameter that may not always be present in the URI. You may do so by placing a ? mark after the parameter name. Make sure to give the route’s corresponding variable a default value:

So, we’re using DB::raw() for all select statement, also repeating the same condition in groupBy(). Here’s the visual result for my dummy seeded data:

Yes, its possible to set connection name if your model extends to Illuminate\Database\Eloquent\Model;