Posted by Jens on 11/29/05 10:45

Hi,

Select ISNULL(Table1.col2,0) - ISNULL(Table2.col2,0)
FROm Table1
FULL OUTER JOIN Table2
ON Table1.Col1 = Table2.Col1

HTH, Jens Suessmeyer.

• Next in forum: Re: Subtracting two columns from diff tables
• Prev in forum: Re: Format() Function in MS SQL
• Thread view: Re: Subtracting two columns from diff tables

[Reply to this message]