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_idaspivot_booking_id,pivot_booking.category_idaspivot_category_id,pivot_booking.countaspivot_countfrompivot_bookinginner joinpivot_bookingonpivot_booking.id=pivot_booking.category_idwherepivot_booking.booking_id= 1255)
Need quick help.