Merge columns from two SQL query results with different number of columns

Question

I've two tables which have following columns:

ERD

Now I want have a SQL query which gives me an output as follows: SQL output

I wrote already some SQL code, but this doesn't work because the union operator needs the same number of columns with the same type. Have a look.

SELECT *
FROM
(SELECT User_tbl1.Username, User_tbl1.Surname, User_tbl1.Givename
FROM User_tbl1
UNION
SELECT User_tbl2.User_PK
FROM User_tbl2)

Can someone help me to bring my SQL query working, so that it will output a hyphen at surname and givename if the record is located in table "User_tbl2"?

Thanks a lot!

Your UNION clause is totally wrong... Post some sample data and ur desired output. — Teja
– Teja, Commented Mar 2, 2012 at 14:36

Diego · Accepted Answer · 2012-03-02 14:39:26Z

5

As simple as:

SELECT User_tbl1.Username, User_tbl1.Surname, User_tbl1.Givename
FROM User_tbl1
UNION
SELECT User_tbl2.User_PK, '-', '-'
FROM User_tbl2

answered Mar 2, 2012 at 14:39

Diego

18.5k5 gold badges67 silver badges68 bronze badges

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

Collectives™ on Stack Overflow

Merge columns from two SQL query results 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