The Edit tab allows you to view and write complex SQL statements that cannot be defined using the Design tab.

• When switching from the Design tab to the Edit tab, the SQL constructed in the Design tab is displayed as a complete SQL statement.

• You can also write dynamic SQL queries directly in the Edit tab. Refer to the section on writing dynamic SQL queries for more details.

The SQL written or modified in the Edit tab will be used as the final SQL for compilation.

Handling SQL Overwrites

If you modify a query in the Edit tab and later switch to the Design tab, make changes, and return to the Edit tab, you will encounter a prompt:

• Yes: The SQL in the Edit tab will be overwritten by the newly constructed SQL from the Design tab.

• No: The SQL in the Edit tab will remain intact and will be used as the final SQL.

This mechanism helps prevent accidental overwriting of complex queries.