Home » RDBMS Server » Server Administration » Updating values from one table to another
Updating values from one table to another [message #373102] Tue, 27 March 2001 14:39
Tammy
Messages: 6
Registered: March 2001
Junior Member
How to update a value from one table to another .
I need to update a value in one table with a value in another table based on
a certain date.
What is the proper syntax.

update table B from Table A where date > 'given date'

Table A Table B
emp_salary fullemp_sal
emp_date

Thank you,
Tammy Jordan

Report message to a moderator

Previous Topic: Database Failures
Next Topic: Adding users as a batch job from a disk file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 06:18:09 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.