Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
2
Reply
Adding value from One Table To Another And Update values
Sumar Khan
Feb 26 2016 1:16 PM
360
Reply
I have two tables A and B In Sql:
A
Id Name Weight
1 Wheat 20 kg
2 Rice 30Kg
B
Name Weight
Wheat 10kg
I want to Add value of Wheat from Table A to B and update values according Like that
After Adding 20kg in B The value of Wheat In Table B would become 30kg and Value of Wheat in A become 0...
Plz Kindly tell me What query Will apply in Sql to such Scenario
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
Failed to login to session state SQL server for user MyUser.
delete record particular year