Sven K�hler > > hi, > > i've got two tables. each table has column a and b > > table1 contains the values > (1, 1) > (1, 1) > > and table2 contains the values > (2, 2) > (2, 2) > > but > SELECT a,b FROM table1 UNION SELECT a,b FROM table2 > returns > (1,1) > (2,2) > > but i expected all 4 rows to be returned.
Then you have to use UNION ALL . Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
