how to substract two value in two tables in sql database

Use a temporary table...

in a temporary table, #temp1 store your 1st table and in temporary table #temp2, you can store your 2nd table.

then create a new table by creating its column name and when you create price column then you can perform subtraction.

here is the sample code

CREATE TABLE #temp1 (

Product VARCHAR(100),

Price int

)

CREATE TABLE #temp2 (

Product VARCHAR(100),

Price int

)

CREATE TABLE #Subs (

Product VARCHAR(100),

Price int

)

INSERT INTO #temp1

SELECT Product,Price FROM table1

INSERT INTO #previousyear

SELECT Product,Price FROM table2

INSERT INTO #Subs

SELECT t1.Product as Product, t1.Price - t2.Price as diff

FROM #temp1 t1 JOIN #temp2 t2 ON t2.Product, = t1.Product

SELECT * FROM #Subs

1 Reply

Know the answer? Post it — somebody with the same question will find it here.