To edit the SQL source for a query:
- Go to Admin > Developer Links > Schema Browser.
- Using the navigation tree on the left, browse to the target query and then click Edit Source.
- The SQL source appears in the source editor.
- Select the Data tab or click Execute Query to see the results.
- Return to the Source tab to make your desired changes.
- Clicking Save will check for syntax errors (such as the trailing comma in the above source).
- Return to the Data tab or click Execute Query again to see the revised results.
- Click Save and Finish to save your changes when complete.