Update field based on data in other table 1

[bmc1234]

I have one table called TableA with two fields for Partnumber and Serialnumber. I want to add another field called repairID and fill it as follows:

In a second table called TableB, there is a repairID as the primary key and Partnumber and SerialNumber fields. these two fields, when paired together are unique in this table. I want to fill TableA.repairID with TableB.repairID by matching the parnumber and serialnumber from the two tables. Does anybody know how to do this? Thanks.

 

[PHV]

Perhaps this ?
UPDATE TableA A INNER JOIN TableB B ON A.Partnumber = B.Partnumber AND A.SerialNumber = B.SerialNumber
SET A.repairID = B.repairID

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

 

[bmc1234]

amazing, thanks! It works like a charm.