why i cannot use where on join clousure ?

[wznuhidayat]

->left_join('follower as uf2', function($join) {
$join->on('uf1.follower_id', '=', 'uf2.followed_id')
->where('uf2.follower_id', '=', Session::get('user_id'));
})

[esyede]

@wznuhidayat Hi, correct. The join's on() method isn't bound to a query class, so you can't chain any other method on those. You can try to put the where clause outside of closure like this:

DB::table('users')->left_join('follower as uf2', function ($join) {
    $join->on('uf1.follower_id', '=', 'uf2.followed_id');
})
->where('uf2.follower_id', '=', Session::get('user_id'))
->select()
->to_sql(); // Use ->get() to retrieve the results

Query result:

SELECT * FROM `users` LEFT JOIN `follower` AS `uf2` ON `uf1`.`follower_id` = `uf2`.`followed_id` WHERE `uf2`.`follower_id` = ?

[wznuhidayat]

Thank you, I think this is going to work.