Update field values from one table to another

[amillia]

UPDATE dbo.SoftOwnIndex, dbo.tblSoftwareOwnerComp SET dbo.SoftOwnIndex.Competency = [dbo.tblSoftwareOwnerComp].[Competency]
WHERE ((([dbo.softOwnIndex].[SOKey])=[dbo.tblSoftwareOwnerComp].[Pkey]))

The thing is that I get an error at the first comma. So I thought I would take out the second table name but then I get an error that it doesn't recognize the [dbo.tblSoftwareOwnerComp].[Competency] field.

So How should I right this? Maybe I need to select the field first but I don't know the syntax. Please Help!

 

[gmmastros]

This syntax shoudl work for you.

UPDATE [dbo].[SoftOwnIndex]
SET    dbo.SoftOwnIndex.Competency = [dbo].[tblSoftwareOwnerComp].[Competency]
From   dbo.SoftOwnIndex
       Inner Join dbo.tblSoftwareOwnerComp 
         On [dbo].[softOwnIndex].[SOKey]= [dbo].[tblSoftwareOwnerComp].[Pkey]

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[amillia]

Thank you, it worked beautifully.