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 is an advanced SQL Query Tool and SQL Editor. Its purpose is to help you extract information
from your database in a way that is simple, quick, accurate and efficient.
Work with your SQL Server, ASE, SQL Anywhere and Oracle databases in
one single application.
"QweryBuilder is a great, easy to use tool, that is a part of my everyday programmer life."
Read More Testimonials