Update query 1

[jlg5454]

I want to update data in a field from one table with data from another table.

I tried something like this which gave me an error:
UPDATE 1stDump SET NewTeam = (SELECT [NewTeam] FROM NewTeamName)
WHERE PP_Number in (SELECT [PP_Number] FROM NewTeamName);

The field I want to update is NewTeam. PP_Number is common in both fields.

Thanks for any help

 

[PHV]

You may try this:
UPDATE [1stDump] AS O INNER JOIN NewTeamName AS N ON O.PP_Number = N.PP_Number
SET O.NewTeam = N.NewTeam

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jlg5454]

Great! Perfect! Thanks for your help.