update command
UPDATE [findahome].[dbo].[Ad_Bank] SET Balance = 2000 where idAgencyOffice IN (SELECT idOffice
from [findahome].[dbo].[AgencyOffice] ao
JOIN [findahome].[dbo].[Agency] ag ON ao.idAgency = ag.idAgency
WHERE ag.idAffiliation = 3)
Insert command
INSERT INTO [findahome].[dbo].[Ad_Bank](idAgencyOffice,Balance)
SELECT idOffice, 2000
from [findahome].[dbo].[AgencyOffice] ao
JOIN [findahome].[dbo].[Agency] ag ON ao.idAgency = ag.idAgency
WHERE ag.idAffiliation = 3