UPDATE MULTIPLE TABLE VALUES INTO SINGLE TABLE - SQL

update [dbo].[Validation] set TestCaseID = tc.TestCaseID

from TestCases tc

join tbl_TestCases t on t.TestCaseName = tc.TestCaseName