SQL 2008 :-
I have two SQL Tables of same column names. I want to subtract Table 2 [SumOCPO] from Table 1 [SumTR]
i.e) Output = SumTR - SumOCPO - Based on Common Column Name : [Generic Code].
I have attached sample 10 rows of each table in an excel sheet and projected output in the same excel sheet.
If experts can come up with logical query will be greatly helpful. This excel sheet is easy to import to SQL Database and can be tested very easily !!!