sql server 2008 - How to get union of two tables with different alias -


i want union want show 1 column twice different alias. e.g

select first table1  union  select second table1 

it shows first output.

but want show both first , second. how can achieved in mssql?

union combines results 2 queries 1 set of columns. there's no way make column name change halfway down. closest can think of

select first , null second  table1   union   select null first , second  table1 

Comments

Popular posts from this blog

html5 - What is breaking my page when printing? -

html - Unable to style the color of bullets in a list -

c# - must be a non-abstract type with a public parameterless constructor in redis -