MyEclipse Visual SQL Query Editor Overview

1. Introduction

This document presents an overview of the Visual SQL Query Editor available in MyEclipse. This editor can be used 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 use wizards.

To get a better feel for MyEclipse, please check our product Documentation for more material.

2. Using the Editor to Build a Query

The Visual SQL Query editor can be opened from our existing SQL editor by selecting 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 using the Open With submenu.

You may also use the connection's context menu in the DB Browser view.

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 the two.

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.

Use the Groups tab to group the results by the CUSTOMERNAME column.

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.