Rules for Using Scalar Subqueries With MERGE Requests You cannot specify scalar subqueries in MERGE requests.