SQL UPDATE Query With values of another table column

Question

There are three tables

Email  
ID  
10  
11  
12  

SLA_DATE     
ID    |    Email_ID  
21    |    10  
22    |    11  
23    |    12  

SLA    
ID    |    Email_ID  
33    |    10  
34    |    11  
35    |    12

I am trying to update the SLA Email_ID from Email.ID to SLA_DATE.ID. So, after updating the SLA, the table should look like

SLA    
ID    |    Email_ID  
33    |    21  
34    |    22  
35    |    23

Below is what i have tried so far..

UPDATE SLA SET 
SLA.Email_ID = SLA_DATE.ID WHERE SLA_DATE.Email_ID = SLA_EMAIL_ID

Tim Biegeleisen · Accepted Answer · 2016-08-30 15:28:18Z

3

UPDATE s
SET s.Email_ID = d.ID
FROM SLA s
INNER JOIN
SLA_DATE d
    ON d.Email_ID = s.Email_ID

edited Aug 30, 2016 at 15:28

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

answered Aug 30, 2016 at 15:26

TheGameiswar

29k9 gold badges67 silver badges106 bronze badges

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

Comments

Joe C · Accepted Answer · 2016-08-30 15:27:52Z

0

This should work

Update S SET S.EmailID = D.ID
   From SLA A
   Join SLA_DATE D On D.Email_ID = S.Email_ID

answered Aug 30, 2016 at 15:27

Joe C

3,9832 gold badges14 silver badges33 bronze badges

Collectives™ on Stack Overflow

SQL UPDATE Query With values of another table 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