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.

[Back to original message]