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

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - SQL Usage » Querying and Modifying Data » Joins: Retrieving data from several tables » How joins work


Using joins in delete, update, and insert statements

You can use joins in DELETE, UPDATE, INSERT, and 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].