transfer data in one table to another table's column

I have two tables.  AttendanceGrid and frmRegistrationCSW.  AttendanceGrid has duplicated IDs and frmRegistrationCSW has NO duplicated IDs

I have several records in frmRegistrationCSW where the ID is related to the ID in AttendanceGrid.  For example ID # 784 in frmRegistrationCSW is the referenced to ID # 784 in AttendanceGrid

There is an Age column in frmRegistrationCSW that I would like to copy to all equivalent records in AttendanceGrid.AgeReg

Is the following code correct for doing this?

UPDATE R14
SET R14.AgeReg= R13.Age
from AttendanceGrid R14
INNER JOIN frmRegistrationCSW AS R13
      ON R13.ID = R14.ID
      AND R13.fiscal = 2014

Open in new window

al4629740Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sameer2010Commented:
This is correct.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TempDBACommented:
Its perfectly fine. That's how we update a table when joining with other table.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.