Add values from multiple columns from different tables to a new column

Is there any simple way to add values from two tables and create a new column? The tables have many-many relationship. Thanks