Adding multiple columns of multiple tables into one column

Question

I have two tables with same column name I have to add the oprId column values for some specific condition on both tables.

Table 1

something  oprId

abc          1
qwe          2

Table 2

something  oprId

abc          2
qwe          5

Result should be

oprId
3
7

I think you have left out the important part of the question. Where does 3 and 7 come from? — Mikael Eriksson
– Mikael Eriksson, Commented Oct 20, 2011 at 17:36
Ok. So you join xyz to abc and ghj to qwe? Are those values parameters to the query? — Mikael Eriksson
– Mikael Eriksson, Commented Oct 20, 2011 at 17:39

Mikael Eriksson · Accepted Answer · 2011-10-20 17:42:36Z

1

declare @T1 table (something varchar(3), oprId int)
declare @T2 table (something varchar(3), oprId int)

insert into @T1 values ('abc', 1),('qwe', 2)
insert into @T2 values ('abc', 2),('qwe', 5)

select T1.oprId+T2.oprId as oprId
from @T1 as T1
  inner join @T2 as T2
    on T1.something = T2.something

Result:

oprId
------
3
7

answered Oct 20, 2011 at 17:42

Mikael Eriksson

139k22 gold badges223 silver badges293 bronze badges

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

Comments

Lamak · Accepted Answer · 2011-10-20 17:41:29Z

0

SELECT ISNULL(A.something,B.something) Something,
       ISNULL(A.oprId,0)ÍSNULL(B.oprId,0) oprId
FROM Table1 A
FULL JOIN Table2 B
ON A.something = B.something

answered Oct 20, 2011 at 17:41

Lamak

70.8k12 gold badges119 silver badges119 bronze badges

Collectives™ on Stack Overflow

Adding multiple columns of multiple tables into one column

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