Getting Different column values from Multiple tables in SQL Server

Question

I have following data in SQL Server tables:

id  Sal
1   100
2   200

id  Wages
1   600
2   800

I want the output as following:

id   Sal/Wages
1    100
1    600
2    200
2    800

How I can do that using a SELECT statement in SQL Server?

I'm not totally sure if I got the question, but have you looked into the UNION and the ORDER BY statement? — Onkel Toob
– Onkel Toob, Commented Sep 14, 2013 at 9:58

Indi · Accepted Answer · 2013-09-14 10:06:00Z

2

Use UNION ALL

Select Id, sal as [sal/wages]
from table1
UNION ALL
Select Id, wages as [sal/wages]
from table2
Order by id,[sal/wages]

If you don't need duplicate records then just use UNION

edited Sep 14, 2013 at 10:06

answered Sep 14, 2013 at 9:59

Indi

33.9k7 gold badges61 silver badges80 bronze badges

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

Comments

roman · Accepted Answer · 2013-09-14 10:20:13Z

1

use union all:

select id, sal as [sal/Wages] from table1
union all
select id, wages as [sal/Wages] from table2
order by 1

Note that I've used union all and not union, because union removes duplicates from resulting set. Sometimes it might be useful, but not in your case, I think.

edited Sep 14, 2013 at 10:20

answered Sep 14, 2013 at 9:58

roman

118k30 gold badges205 silver badges209 bronze badges

Collectives™ on Stack Overflow

Getting Different column values from Multiple tables in SQL Server

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related