減去數值的運算在不同表格中的應用

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