2个表的3个值之间的差异

Question

我有两张桌子，就像

id  att1 att2
1   34    56
2   45    12
3   34    11


id  att1 att2
1   14    10
2   25    2
3   14    10

如何获得3个值之间的差异，例如

id      att1      att2
1-1=0  34-14=20  56-10=46
2-2=0  45-25=20  12-2 =10  
3-3=0  34-14=20  11-10=1 


SELECT A.id-B.id, A.att1-B.att1,A.att2-B.att2 from TABLEA as A join TABLEB as B...

Answer 1

不确定你正在寻找的东西，你已经在你的问题中没有提供。你是说像这样的东西吗？

SELECT
    CAST(A.id AS VARCHAR(200)) + '-' +  CAST(B.id AS VARCHAR(200)) + '=' + CAST(A.id - B.id AS VARCHAR(200)) id
    ,CAST(A.att1 AS VARCHAR(200)) + '-' +  CAST(B.att1 AS VARCHAR(200)) + '=' + CAST(A.att1 - B.att1 AS VARCHAR(200)) att1
    ,CAST(A.att2 AS VARCHAR(200)) + '-' +  CAST(B.att2 AS VARCHAR(200)) + '=' + CAST(A.att2 - B.att2 AS VARCHAR(200)) att2
FROM
    TABLEA A
    INNER JOIN TABLEB B ON A.id = B.id

Answer 2

您并不是真的想从一个id中减去另一个id，对吗？

SELECT
  A.id,
  A.att1 - B.att1,
  A.att2 - B.att2
FROM
  A JOIN B ON A.id = B.id