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

INSERT MULTIPLE TABLE VALUES INTO SINGLE TABLE - SQL QUERRY

INSERT INTO [dbo].[TestCases]
(
[Projectid],
[TestCaseName],
[SourcePath],
[DestinationPath],
[Xpath],
[LogicalOperator],
[Value],
[ConnectionString] ,
[TestFilesPath],
[SearchPattern]
)

SELECT

p.[Projectid],
tc.[TestCaseName],
tc.[SourcePath],
tc.[DestinationPath],
tc.[Xpath],
tc.[LogicalOperator],
tc.[Value],
tc.[ConnectionString] ,
tc.[TestFilesPath],
tc.[SearchPattern]

from [dbo].[tbl_TestCases] tc

join tbl_Projects pr on tc.Projectid = pr.ProjectId
join [dbo].[Projects] p on p.ProjectName = pr.ProjectName