如何将两列的值相加?

Question

有两张表:

|column1|column2|
|------ |----   |
| A     |B      | 
|A1     |    B1 |
|A2     |B2     |

和

|column1a|column2a|
|------- |----    |
| A      |C       |
|A1      |C1      |
|A2      |C2      |

从这个我想要a像这样的表:

|newColumn|newColumn2|
|------- |----       | 
| A      | B + C     |
|A1      |B1 + C1    |
|A2      |B2 + C2|

希望你能帮助我;)

Answer 1

在那个简单的情况下(它真的那么简单吗?这些表中没有其他行吗?)，然后

SQL> select * from table1;
A
----------
10
SQL> select * from table2;
B
----------
2
SQL> create table table3 as
2    select t1.a + t2.b as c
3    from table1 t1 cross join table2 t2;
Table created.
SQL> select * from table3;
C
----------
12
SQL>

Answer 2

将列值转换为NUMBER

SELECT CAST(table1.A AS NUMBER)+CAST(tableb.B AS NUMBER) as Sum
From table1 INNER JOIN tableb ON table1.Id=tableb.Id