top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

How can I do an UPDATE statement with JOIN in SQL?

+1 vote
45 views
How can I do an UPDATE statement with JOIN in SQL?
posted Jun 30, 2015 by Shivaranjini

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

1 Answer

+2 votes

update emp1
set emp1.emp1id = emp2.emp1id
from emp2 emp1
inner join sale emp2 on
emp1.id = emp2.emp2id

answer Jun 30, 2015 by Priyadharshini Kunjithapatham
Similar Questions
+1 vote

Forums

ID
Name
Description

Questions

ID
UserID
ForumID
Title
QuestionText
CreateDateTime

Replies

ID
UserID
QuestionID
ReplyText
CreateDateTime

users

UserID
UserName

I want to retrieve name of each forum, number of questions of each forum, number of replies of each forum, last post's UserName and date for each forum.

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...