Pergunta de entrevista da empresa Tech Mahindra

Write a Query in SQL to update the value columns in a Table among 3 Tables with some conditions?