Home Forums SQL Server 2005 T-SQL (SS2K5) how to compare two table and save result into 3rd table RE: how to compare two table and save result into 3rd table

  • Join the two tables on number=number and do t1.sec - t2.sec for the second column of your result set. Make sure you know how you will handle the cases where the subtraction produces a negative number.

    John