update records using subquery

A Subquery is a query within another query. The outer query is called as main query and inner query is called as sub query.