Resta de 2 tablas

[ambichol]

seria algo similar a esto:

Código SQL:

CREATE TABLE #t1(
def VARCHAR(50),
total FLOAT
)
CREATE TABLE #t2(
def VARCHAR(50),
total FLOAT
)
INSERT INTO #t1 VALUES('Objeto1','10.20')
INSERT INTO #t1 VALUES('Objeto2','100.30')
INSERT INTO #t2 VALUES('Objeto1','500.45')
INSERT INTO #t2 VALUES('Objeto2','895.14')
 
SELECT a.def,a.total AS Cantidad1, b.total AS Cantidad2, (a.total-b.total) AS Resta
FROM #t1 a INNER JOIN #t2 b
ON a.def = b.def