SELECT cAssUnit,Inventory.cSTComUnitCode,*--UPDATE rdrecords01 SET cAssUnit Inventory.cSTComUnitCodeFROM rdrecords01 LEFT JOIN Inventory ON rdrecords01.cInvCode Inventory.cInvCode