> Could someone please post the results of these queries on Oracle, 
> DB2 or SQL Server? 

On MS SQL Server 2000, your queries result in the following:

          a           c
----------- -----------
          2        -998
          1           3

(2 row(s) affected)

        foo
-----------
      -1000
          1
          2

(3 row(s) affected)

          a           c
----------- -----------
          2        -998
          1           3
          1           4
          2           5

(4 row(s) affected)


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to