How to add new column from another table based on a condition in sql server

Question

Table A

Org ID  int not null

Org Name varchar

Table B

AccountID int not null

OrgID  int not null

I want to add the AccountID column into Table A from Table B based on the condition

A.Org ID = B.Org.ID

Can anyone help me how to do this?

have you tried this and seeing any issue? can you paste the code that you tried? — radar
– radar, Commented Oct 31, 2014 at 16:47
I am not sure which one to use like update set commands, merge, inner join ?? — Shiningstar
– Shiningstar, Commented Oct 31, 2014 at 16:54
could u please advise the sample query based on the question above? — Shiningstar
– Shiningstar, Commented Oct 31, 2014 at 16:57
added the answer, you can build on top of this for next time you have to do such updates with joins — radar
– radar, Commented Oct 31, 2014 at 17:03

radar · Accepted Answer · 2014-10-31 17:08:01Z

2

UPDATE A
SET A.AccountID = B.AccountID
FROM TableA A
JOIN TableB B
on A.OrgID = B.OrgID

edited Oct 31, 2014 at 17:08

answered Oct 31, 2014 at 17:02

radar

13.4k2 gold badges27 silver badges33 bronze badges

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

9 Comments

Shiningstar Over a year ago

I am getting the following error Msg 2705, Level 16, State 4, Line 1 Column names in each table must be unique. Column name 'AccountID' in table 'dbo.Whitespace' is specified more than once. Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "A.AccountID" could not be bound.

radar Over a year ago

@Shiningstar, looks like you already have the accountid column, then just ry the upadate

Shiningstar Over a year ago

Now I am getting following error Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "A.AccountID" could not be bound.

radar Over a year ago

@Shiningstar, does the column AccountId exists ? have you tried adding it to correct table?

Shiningstar Over a year ago

No..Table A doen't have [AccountID] column. @RADAR

|

Collectives™ on Stack Overflow

How to add new column from another table based on a condition in sql server

Table A

Table B

1 Answer 1

9 Comments

Hot Network Questions

Collectives™ on Stack Overflow

Table A

Table B

1 Answer 1

9 Comments

Related