Mar 30, 2023
0
Level 1
Eloquent orWhere Join query makes error
I have this query:
$hasBorrowedCars = CarBorrow::query()
->where('borrowed_from_user_id', $userId)
->orWhere(function ($query) use ($userId) {
$query->join('car_owners', 'user_id', '=', 'car_owners.user_id')
->where('car_owners.user_id'', $userId);
})
->exists();
but makes me this error:
Unknown column 'user_id' in 'where clause' (SQL: select exists(select * from `car_borrows` where `borrowed_from_user_id` = 2 or (`user_id` = 2)) as `exists`)
Please or to participate in this conversation.