Sql update trouble

Question

Please see the screenshot below. I am trying to update tid with sid where teacher's emailaddress equals student's email address. I've tried different methods and it's either I get an empty result or multipart identifier error. Kindly help.

screenshot of the problem

For instance, the kind of answer I expect would be, tid on row 1 would be 3, row 2 would be 2, row3 would be 2, and row 4, 1

Please post the query you attempted. This should be very straightforward `WHERE studentemail = teacheremail` — Michael Berkowski, Jun 18 '13 at 20:55
Can you show what you have tried, so that we can guide you appropriately with your homework? — Guffa, Jun 18 '13 at 20:57
Here another [tsql - updating a table from a select statement](http://stackoverflow.com/a/17047692/1563878) — Gaston Flores, Jun 18 '13 at 21:46

score 1 · Accepted Answer · answered Jun 18 '13 at 21:03

1

Should just be something simple like

Update s
Set tid = t.sid
From table s
Inner join table t on s.teacheremail = t.studentemail

answered Jun 18 '13 at 21:03

Rowland Shaw

37,700
14
97
166

You did it! Thanks a lot! – bdfios Jun 18 '13 at 21:17

Sql update trouble

1 Answers1