Query By Example (QBE)

How To

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:

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.