Stuck with simple Update

From: <pankaj_wolfhunter_at_yahoo.co.in>
Date: 22 Nov 2006 07:48:25 -0800
Message-ID: <1164210505.284520.128710@h54g2000cwb.googlegroups.com>

Greetings,

            This may sound a stupid question but I dont know where else to go.

SQL> SELECT SUM(id1) - (SUM(id2) + SUM(id3)) RESULT   2 FROM table1

    RESULT

---

 225584455

SQL> SELECT SUM(RESULT_TMP) RESULT
  2 FROM (
  3 SELECT id1 - (id2 + id3) RESULT_TMP   4 FROM table1
  5 );

    RESULT

---

 225572755

 Why am I getting two different results.  What am I dng wrong here?

 I am using Oracle 10g Enterprise Edition  

 Any help would be greatly appreciated.  

 TIA Received on Wed Nov 22 2006 - 09:48:25 CST