Some time you want to update a column in a table from another table’s column and in magento 2 you can use “updateFromSelect” function to do it.
- This is an example in resouce model
- And this is the query after the code is render
UPDATE `maintable` AS `maintable`
INNER JOIN `maintable`
LEFT JOIN `'join_table'` AS `'join_table'` ON main_table.id = 'join_table'.id
SET `'main_table'`.`name` = `'join_table'`.`name`
Hope it helpful for you.
The steps I mention above is the shortest process for you to Update a Column in a Table from Another Table’s Column in Magento 2.
Thank you for reading this post and see you in other posts from Magestore!
Ready to foster your knowledge
Is your site still a mess and Magento extensions are not enough to save your site? Save your site with Magento Web Development Services now