After you connect a database to the IDE, you can access the database tables in the database connection. By default, the IDE retrieves all data in a given database table. To retrieve a specific part of the data, create an SQL query in the Visual SQL Editor. An SQL query determines which data to retrieve from or write back to the table in the database connection. A typical SQL query might be a SELECT statement that determines which rows to retrieve based on restrictions in the WHERE clause.
To create an SQL query:
You can create the query graphically by using the top two panes or type and edit the SQL code in the third pane.