减去数值的操作在不同表中的应用

Question

我有两个表：

表A
ID  Number Profile
1   100     Baker
2   75      Fields
3   100     Wayward

表B
ID  Number Tag  Sender
1   50      on  chris
2   50      off james

我试图从表A和表B中减去具有相同ID号的值

表C
ID  Number
1   50
2   25

Answer 1

SELECT A.ID,A.NUMBER-B.NUMBER DIFF
FROM TABLE_A AS A
JOIN TABLE_B AS B ON A.ID=B.ID