Download free trial

Visual SQL Query Builder

Visually create complex SQL queries

MyEclipse 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 use wizards.

The 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.

Getting Started

Working with the SQL Query Builder in MyEclipse begins with right-clicking on your SQL file, and going to Open With > MyEclipse Visual SQL Query Editor

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

Easily select tables to use in your query.

Example: creating a join is as simple as a mouse drag.

Including an expression result in your output, by selecting Build Expression... from the Column combo.

Example of a finished query...

Resources

• Download a MyEclipse 30-day trial edition

MyEclipse Innovations

The innovation and application of Eclipse technology is Genuitec's sole business. With well over 10 million downloads, our MyEclipse Enterprise Workbench product has grown to be the most popular and successful Eclipse-based JEE IDE. Our long chain of Eclipse technology innovation includes:

• First JSR-045 compliant source-level JSP debugger for Eclipse
• First IE debugger that supports remote debugging of deployed applications
  
• First public article explaining that Eclipse could be used as a rich-client platform in early 2002
• First commercial RCP applications shipped on Eclipse 2.0, well before the Eclipse 3.0 RCP
• First and most comprehensive suite of application server connectors for Eclipse
• First 'hot sync' JEE application deployer to enable continuous web development without server restarts
• First native JavaScript debugger for Eclipse
• First Web 2.0 / Ajax feature-set for Eclipse
• Most database connectors supported on Eclipse
• First IDE to fully support Hibernate / Spring integration
• First full-featured image editor for Eclipse
• First Eclipse IDE to offer a low-cost, all-inclusive subscription pricing model
• First IDE to integrate NetBeans features into Eclipse
• First to create platform-independent RCP applications with SNAPs

Download free trial

Visual SQL Query Builder

Visually create complex SQL queries

MyEclipse 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 use wizards.

The 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.

Getting Started

Working with the SQL Query Builder in MyEclipse begins with right-clicking on your SQL file, and going to Open With > MyEclipse Visual SQL Query Editor

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

Easily select tables to use in your query.

Example: creating a join is as simple as a mouse drag.

Including an expression result in your output, by selecting Build Expression... from the Column combo.

Example of a finished query...

Resources

• Download a MyEclipse 30-day trial edition

MyEclipse Innovations

The innovation and application of Eclipse technology is Genuitec's sole business. With well over 10 million downloads, our MyEclipse Enterprise Workbench product has grown to be the most popular and successful Eclipse-based JEE IDE. Our long chain of Eclipse technology innovation includes:

• First JSR-045 compliant source-level JSP debugger for Eclipse
• First IE debugger that supports remote debugging of deployed applications
  
• First public article explaining that Eclipse could be used as a rich-client platform in early 2002
• First commercial RCP applications shipped on Eclipse 2.0, well before the Eclipse 3.0 RCP
• First and most comprehensive suite of application server connectors for Eclipse
• First 'hot sync' JEE application deployer to enable continuous web development without server restarts
• First native JavaScript debugger for Eclipse
• First Web 2.0 / Ajax feature-set for Eclipse
• Most database connectors supported on Eclipse
• First IDE to fully support Hibernate / Spring integration
• First full-featured image editor for Eclipse
• First Eclipse IDE to offer a low-cost, all-inclusive subscription pricing model
• First IDE to integrate NetBeans features into Eclipse
• First to create platform-independent RCP applications with SNAPs