diff options
| -rw-r--r-- | doc/src/sgml/ref/merge.sgml | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/merge.sgml b/doc/src/sgml/ref/merge.sgml index c547122c9bb..ac1c0a83dd2 100644 --- a/doc/src/sgml/ref/merge.sgml +++ b/doc/src/sgml/ref/merge.sgml @@ -596,7 +596,7 @@ ON s.winename = w.winename WHEN NOT MATCHED AND s.stock_delta > 0 THEN INSERT VALUES(s.winename, s.stock_delta) WHEN MATCHED AND w.stock + s.stock_delta > 0 THEN - UPDATE SET stock = w.stock + s.stock_delta; + UPDATE SET stock = w.stock + s.stock_delta WHEN MATCHED THEN DELETE; </programlisting> |