> 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]
-----------------------------------------------------------------------------