I am trying to join two tables like below
$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$collection = $objectManager->get('Advance\Module\Model\Method')
->getCollection()->addFieldToFilter('stores', ['finset' => $store_id]);
$collection->getSelect()->joinLeft( ['shippingrate'=> 'shippingrate'],
'shippingrate.method_id = main_table.method_id', ['main_table.method_id']);
This is returning all data from two tables. I could not get specific columns from the end result.