--- Robert Wishlaw <[EMAIL PROTECTED]> wrote: > > > CREATE TABLE t1(a,b,c);
> IBM DB2 9.5 > > INSERT INTO t1 VALUES(1,2,4); > SELECT a+b AS c FROM t1 WHERE c=4; > > returns > > C > -------------------- > 3 > 3 > 3 > 3 > 4 record(s) selected How could more than one row be returned if t1 only has one row? ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------