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.
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
