Magento 2: join custom table with product collection while sql query is running fine
I finallly found solution. Actually collection making alias for join table. You don't have to set alias
$joinConditions = 'e.entity_id = store_price.product_id';
$collection->addAttributeToSelect('*');
$collection->getSelect()->join(
['store_price'],
$joinConditions,
[]
)->columns("store_price.product_price")
->where("store_price.store_id=1");