union

[sukasom chaiyakul]

I want to combine the result from many select statement.

(
select paperid from .....
)
union
(
select paperid from .....
) ;

For example, the select statement returns 32, 34, 31, 35

The second select statement returns 33, 36, 37 ,38


but it returns 31,32,34,35,33,36,36,38

and i want the result to be 32, 34, 31, 35, 33, 36, 37 ,38

Do you have any idea?