update query

I have table TUBEDATA where each record has fields PartNumber and SerialNumber.

I have a second table CURRENT LOCATION with fields PartNumber and SerialNumber.  The records all have the SerialNumber but none the PartNumber

I need an update query to update all the records in table CURRENT LOCATION with PartNumber from table TUBEDATA.

Thanks,
Brooks
gbnortonAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
try this update query

update [CURRENT LOCATION] as CL
Inner join TUBEDATA as TD
on CL.SerialNumber= TD.SerialNumber
set CL.Partnumber=TD.PartNumber
where CL.PartNumber is null
0
 
gbnortonAuthor Commented:
Perfect.  Thanks!
Brooks
0
All Courses

From novice to tech pro — start learning today.