A work area (top pane), where you select the columns you want in your query, and where you can also easily create joins by dragging column names;
Quickly build complex SQL statements
With SQL Navigator’s Query Builder you can quickly build complex SQL statements by dragging tables from a list into a work area, checking required fields and linking them using a drag-and-drop technique.
The Query Builder window has two resizable panes:
A work area (top pane), where you select the columns you want in your query, and where you can also easily create joins by dragging column names;
A query display area (bottom pane), where you can view your query in two different ways as it is being built: as SQL code, or as a data grid. You can also set criteria in this area.
Sort and group
Query features also include sorting and grouping, a selection criteria builder, and more.
Save and re-use queries
Queries can be saved to disk for later re-use.
