Laravel Error: SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias

Viewed 24

Having three tables, booking, category, pivot_booking.

In Booking model -

public function category()
{
    return $this->belongsToMany(\Modules\Backend\Entities\Category::class, "pivot_booking","booking_id","category_id")->withPivot('count');
}

In Category model-

public function bookings()
{
    return $this->belongsToMany(\Modules\Frontend\Entities\Booking::class, "pivot_booking","booking_id","category_id")->withPivot('count');
}

In my controller, I want to fetch data from both tables as

$booking = \Modules\Frontend\Entities\Booking::with('category')->where('id',$decrypted)->first();

But getting the following error:

SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'pivot_booking' (SQL: select pivot_booking.*, pivot_booking.booking_id as pivot_booking_id, pivot_booking.category_id as pivot_category_id, pivot_booking.count as pivot_count from pivot_booking inner join pivot_booking on pivot_booking.id = pivot_booking.category_id where pivot_booking.booking_id = 1255)

Need quick help.

0 Answers
Related