The MERGE control statement must be used when a merge operation is to be performed; this statement describes the control…