How to select from two different tables to display orders list with custom column from other table

How to select from two different tables to display orders list with custom column from other table