Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Joins: Retrieving Data from Several Tables » Joins overview

Join compatible data types Next Page

Using joins in delete, update, and insert statements


You can use joins in DELETE, UPDATE and INSERT statements, as well as in SELECT statements. You can update some cursors that contain joins if the ansi_update_constraints option is set to Off. This is the default for databases created before SQL Anywhere version 7. For databases created in version 7 or later, the default is Cursors. See ansi_update_constraints option [compatibility].