The Graphic Query window is used to query your database without having to write any SQL.
You design your queries graphically. Tables are opened and columns are displayed. Joining
two tables together requires just 3 clicks of the mouse.
In the image above, the query builder is in join mode (look at the third toolbar button).
What this does is let's you click on a column in one table, then a column in another table.
Doing this creates a graphical join, i.e. the red line with the equal sign attached to it.
To add columns to your SELECT list, make sure that join mode is turned off (the third
toolbar button should not be toggled). Click the column(s) that you want to select within a table. Selected
columns will appear in the Select tab at the bottom of the screen. In this tab, you can change
the order that the columns will be retrieved by draging column up or down.
The functionality of a given tab is best described by the tab name:
- Allows you to add computed expressions to your query.
E.g. Count(*) or LastName + ', ' FirstName
- Group By
- Drag columns from the left to the right side.
- Order By
- Change the order of columns by dragging up or down.
- Displays the generated SELECT statement.
QweryBuilder's SQL Editor provides you with a rich ad-hoc query experience that gives
you full control while you query your database.
Work with your SQL Server, ASE, SQL Anywhere and Oracle databases in
one single application.
"This is a great program, a good developer's tool. It is snappy and to the point. It is the best that I have seen and tried."
Read More Testimonials