CODEWITHSUNDEEP
sqlsybaseunion
aF.
aF.

Reputation: 66697

Sybase SQL union of two different tables

Is it possible to make a union from two tables with different number of columns, values and column types in Sybase SQL?

Upvotes: 0

Views: 3771

Answers (1)

Andomar
Andomar

Reputation: 238076

Sure, as long as the columns from the top and bottom part of the union can be converted to the same type. For example:

select  intColumn as col1
,       charColumn as col2
,       decimalColumn as col3
from    Table1
union all
select  null
,       'Halelujah'
,       doubleColumn
from    Table2

Upvotes: 1

Related Questions