Postgresql Combine two select statement with different number of columns

Question

table1:

tconst attr_a attr_b attr_c

table2:

tconst attr_d attr_e

What I want:

tconst attr_a attr_b attr_c attr_d attr_e

Note: The tconst in table1 and table2 are different numbers, no intersection

Could anyone help? Thanks!

rohitvats · Accepted Answer · 2020-01-22 06:04:20Z

1

You can try something like this, so that both statements in the union have the same number of columns:

select tconst , attr_a , attr_b , attr_c, null attr_d, null attr_e
from table1

union all

select tconst , null attr_a , null attr_b , null attr_c, attr_d, attr_e
from table2

edited Jan 22, 2020 at 6:04

answered Jan 22, 2020 at 5:58

rohitvats

1,85113 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgresql Combine two select statement with different number of columns

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related