Home Forums SQL Server 7,2000 T-SQL Update Table using field from another table RE: Update Table using field from another table
mccork
SSC-Insane
Points: 22288
More actions
July 22, 2003 at 3:52 pm
#466489
UPDATE TableA SET id = TableB.id FROM TableA INNER JOIN TableB ON TableA.xCode = TableB.xCode WHERE TableA.id IS NULL OR TableA.id = ''
Cheers,- Mark