error on left join
I’m getting errors in Left join, below is my code. $motorcyclebookFactory = $this->motorcyclebookFactory->create() ->getCollection() ->addFieldToFilter(‘product_id’, $productCollectionData->getId()); $motorcyclebookFactory->getSelect()->joinLeft( ‘rider_detail as wrd’, ‘wrd.booking_id = main_table.booking_id’, [‘booking_id’, ‘booking_series_id’] ); Error is { “code”: “500”, “message”: “SQLSTATE[23000]: Integrity constraint violation: 1052 Column ‘product_id’ in… Read More »error on left join