If you are not familiar with SQL queries, you should select the Query Dialog. To do so, first connect to the desired database (see Section Connecting to the Database).
The Query item in the Database menu or the~ 
~ toolbar button of the Query Dialog then opens a window where all the queries are displayed that
are accessible to you.
Initially, this window will be empty and you will only be able to design new queries. Select New and describe your query in the following window (see Section Selecting Tables ).
Before you can see the result, you must save the query with Save. Its name can have a maximum length of 150 characters.
If there are already saved queries or if you share queries with other users (see Section New Sharing of Stored Objects), these queries are displayed, ordered by owner. Click on the title bar to order the queries by name. In the title bar, you can see whether the queries are ordered by owner or by name; the sort column is not enclosed in brackets.
If other users allow you to share their queries, you can execute these queries. The owner of a query to be shared can determine whether the sharing user may only execute the query or also read it. If you share a query for execution only, then you cannot change it. If you share it for reading, you can modify and save it as your own query.
See also:
Selection Criteria for a Column
Viewing the Pertinent SQL Statement