Yes. I am aware of Go statement but here I am not using any batch terminator.
Declare @Myvar Tab(Id int, Latesttime DateTime)
Insert into @Myvar (Id, LatestTime)
(select Id, Latesttime from TableA A join TableC C where A.Name=C.Name....)
Update @Myvar
SET V.LatestTIme=B.LatestDate
FROM TableB B
INNER JOIN @Myvar V
ON V.id=B.ID