MERGE statement — F312

BigQueryDb2 (LUW)DerbyH2MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200720092011201320152017201920212023⊘ 3.5.7 - 3.50.0✓ 2008R2 - 2022✓ 15 - 17⊘ 8.3 - 14⚠ 11gR1 - 23.9ab⊘ 5.0 - 9.3.0⊘ 5.1 - 12.0.2⚠ 1.4.198 - 2.3.232a⊘ 1.4.191 - 1.4.197⚠ 10.15.1.3 - 10.17.1.0a⚠ 9.7 - 12.1.2a✓ 2.0
  1. Ambiguities not always reported
  2. The on clause requires parenthesis: on ( <condition> )