how to join 2 table in magento 2 to display out grid listing

[mcspronko]

Hi, can you give me an example of the second table and the grid columns?

[ducquy23]

I have table in database: (Table name: ecommage_blogs (id (pk), title, author_id (a.k.a customer_id), url_key, content, created_at, updated_at, status - 1: publish, 2: draft, 3: non-publish), Now I want to join to the customer_entity table to get the email displayed on the grid listing,I have a reference in some documents, they say just add the _initSelect() method in the Collection.php file and join the table to join and go to the grid listing to see the results. <?php namespace Ecommage\Blogext3\Model\ResourceModel\Blog;

class Collection extends \Magento\Framework\Model\ResourceModel\Db\Collection\AbstractCollection { protected $_idFieldName = 'id'; protected $_eventPrefix = 'ecommage_blogs_collection'; protected $_eventObject = 'blogs_collection'; /**

• Define resource model
• @return void */ protected function _construct() { $this->_init('Ecommage\Blogext3\Model\Blog', 'Ecommage\Blogext3\Model\ResourceModel\Blog'); } public function _initSelect() { parent::_initSelect(); $collection = $this->getSelect()->join( ['b' => $this->getTable('customer_entity')], 'main_table.author_id = b.entity_id', ['author_name' => 'b.email'] ); return $collection; } } but i am not able to display the result of email field to grid listing

[mcspronko]

Sorry, but your question is not related to the repository source code where you ask the question.