Left Join

This method defines a conditional relationship to another table in your query.

Syntax

public function leftJoin(string $table, string|array|Closure $relations): self;

Alias

public function ljoin(string $table, string|array|Closure $relations): self;

Example 1

PHP's way:

$repository->leftJoin('users', 'users.id = orders.user_id');

SQL's Representation:

LEFT JOIN
  users ON users.id = orders.user_id

Example 2

PHP's way:

$repository->leftJoin('products', [
    'brands.id' => 'products.brand_id',
    'categories.id' => 'products.category_id',
]);

SQL's Representation:

LEFT JOIN
  products ON brands.id = products.brand_id AND
  categories.id = products.category_id

Example 3

PHP's way:

$repository->leftJoin('orders', function ($repository) {
    $repository->on('orders.id', '=', 'order_items.order_id');
});

SQL's Representation:

LEFT JOIN
  orders ON orders.id = order_items.order_id

---

🡄 Inner Join | Right Join 🡆