After lots of digging into Magento's core code, I found a solution to my question. Instead of adding a column to the grid via the database, I created a UI ...
use Magento\Sales\Model\ResourceModel\Order\Grid\Collection as ...
Learn how to Add Column in Sales Order Grid in Magento after
However, if you are creating a module that provides additional useful information about orders, it is a good idea to add corresponding columns to the sales order ...
Add more columns to Sales order grid in Magento 2 · Step 1: Create a table · Step 2: Join custom table with our wishlist one · Step 3: Add column ...
... custom column in order grid in Magento 2. Add custom column in order grid Magento 2
Using powerful CMS like Magento 2 helps you to collect all order details so smoothly with its easy checkout navigation steps. And, the main ...
I solved the issue by grouping by entity_id ->group('main_table.entity_id') to remove duplicaded rows and delete LeftJoin to Sales_order table ...
However, despite the lack of time, I do encourage you to read on.. Thus, to add a new column to the orders grid, you need ...