Link and update a table 1

[Michael57]

I need to update a field in one table "Work" based on a value in another table "Job". The two tables should be linked by the field "job#". I want script to update a field "status" in table Work based on the value of "status" in the table "Job".
Can anyone please help me on this. Thanks in advance.

 

[bborissov]

UPDATE Work SET Status = Job.Status
FROM Work
INNER JOIN Job ON Work.JobId = Job.JobId

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP