You can use the Query Editor in Interactive SQL to build SELECT statements. You can create SQL queries in the Query Editor, or you can import queries and edit them.
There are no prerequisites for this task.
Connect to a database from Interactive SQL.
Open the Query Editor.
Click Tools » Edit Query.
If you have a SQL statement selected in Interactive SQL, the selected statement is automatically imported into the Query Editor.
Create your query.
At any time while using the Query Editor, you can click SQL at the bottom of the window to see the SQL statement for the query you are building. You can directly edit the code, and the fields are automatically updated in the Query Editor user interface.
Click OK to write the query to the SQL Statements pane.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|