RE: UNION result is distict?

"Zabach, Elke" <[email protected]> Wed, 13 Aug 2003 14:24:17 +0200

Newsgroups	gmane.comp.db.sapdb.general
Message-ID	<[email protected]>

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