Laravel eloquent join multiple tables in the leftjoin

Question

I'm new in laravel. I'm trying to join multiple tables in the left join however i facing the syntax error and i have no idea where goes wrong.

Code

$query = DB::table('sales')
    ->leftjoin('transactions AS trx', function ($join) {
        $join->on('payment_methods AS payment', 'payment.id', '=', 'trx.payment_method_id');
        $join->on('transactables', 'transactables.transaction_id', '=', 'transactions.id')
            ->whereNull('transactions.deleted_at')
            ->whereNull('transactables.deleted_at')
            ->where('transactable_type', '=', 'Sale')
            ->where('transactable_id', '=', 'sales.id');
    })

The error meesage

Syntax error near '`payment_methods` as `payment` payment.id `=` and `transactions`.`deleted_at` is'

As the code above you can see. I'm trying to join table payment_methods and transactables within the transactions table.

@TsaiKoga which mean i need to join the others two table as sub query? — fife
– fife, Commented Mar 16, 2020 at 3:22
Use multiple leftjoin, or you can call eloquent builder relationship by with. — TsaiKoga
– TsaiKoga, Commented Mar 16, 2020 at 4:02

Saleem · Accepted Answer · 2020-03-16 06:46:32Z

1

Why don't you use the Eloquent like

$sales = Sale::with('transactions')->get();

Add relation in Sale model

public function transactions()
{
    return $this->morphToMany('App\Transaction', 'transactable');
}

For more info, please refer to Laravel docs

answered Mar 16, 2020 at 6:46

Saleem

1,05914 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel eloquent join multiple tables in the leftjoin

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related