Query By Example (QBE) |
The Query By Example (QBE) interface provides you with a streamlined, user-friendly, effective and efficient interface for creating SQL query strings. The interface will guide you through the creation of SQL query strings so that you need no previous programming knowledge. For advanced users the interface makes the creation of SQL query strings a quick and easy process. The QBE interface provides a number of functions to make the creation of SQL query strings a quickly completed task. These functions include:
Single or multi table query support
Table alias name support
Column alias name support
WHERE CLAUSE support
ORDER BY CLAUSE support
Manual SQL query editing support
The QBE interface guides you through a number of steps while creating your SQL query string. When creating an SQL string the string can be based on a single or multi tables. The interface provides a complete list of all tables and views in the database.
The next step is choosing which columns, in the table, will be effected by the query string. You can set an alias name for the tables or the columns. And you can also set the table and column order.