Merge result sets

[itsricky]

Hello,

I know I can do this with UNION but I would like to know some other ways? Is it possible to stack columns within the same table?

Example:

Select col1, col2, col3

Result:

col1
col2
col3

Thanks in advance!

Ricky

 

[juliane26]

No, it would not be SQL then.
UNION is best can do, in this case probably UNION ALL.

Only: when doing that in an application you still can select all three columns and present the data the way you want in only one column.
That way you need only one select statement.


Juliane

 

[itsricky]

I thought so. Thanks anyway Juliane!