MyEclipse 7.5 includes a Visual SQL Query Editor which you can
use to easily create complex SQL queries without having to
remember complex SQL syntax. Visually add tables, create joins,
manage groups, expressions and order your output with easy to
The editor can be opened from our existing SQL editor by
Open in MyEclipse Visual SQL Query Editor from the
context menu. On finish, the query you created will be inserted
into the SQL editor, replacing the selected query, if any.
You can open existing SQL files with the Visual Query editor
Open With submenu.
You may also use the connection's context menu in the DB Browser
Right-click and select
Add Table... to bring up the table selection dialog.
Select a table and click OK to use it in your query.
Simply drag from one column to another to create a join between
To include an expression result in your output, select
Build Expression... from the Column combo.
Choose the type of expression you wish to build.
Here we use the SUM function to return the sum of the AMOUNT
column in the PAYMENT table.
Groups tab to group the results by the CUSTOMERNAME
The finished query can be seen below; to execute this, choose
Run SQL from the source area's context menu.
Results are displayed in the SQL Results view.