UNION result is distict?

Sven Köhler <[email protected]>
Newsgroups gmane.comp.db.sapdb.general
Message-ID <[email protected]> 
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.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.