SQL User's Guide
User Guide (Engelstalig)
De SQL Ontwerper is engelstalig. Naast regelmatige updates en uitbreiding die de makers van dit programmaonderdeel opleveren, is ook een User's Guide uitgegeven. Deze gebruikershandleiding is ook Engelstalig en is voor naslagdoeleinden opgenomen in de Tradium Manuals:
Getting started
The main window can be divided into the following parts:
The Query Building Area is the main area where the visual representation of query will be displayed. This area allows you to define source database objects and derived tables, define links between them and configure properties of tables and links.
The Columns Pane is located below the query building area. It is used to perform all necessary operations with query output columns and expressions. Here you can define field aliases, sorting and grouping, and define criteria.
The Query Tree Pane is located at the left. Here you may browse your query and quickly locate any part of it.
The page control above the query building area will allow you to switch between the main query and sub-queries.
The small area in the corner of the query building area with the "Q" letter is the union sub-query handling control. Here you may add new union sub-queries and perform all necessary operations with them using popup menu.
Working with the SQL query builder you can see only one query or sub-query at the moment. Each single query represented at the Query Building Area and the Column pane.
Learn more:
how to build a query with sub-queries
TradiumTech.nl is voor de technische ondersteuning van Tradium Business Software, kijk op www.tradium.nl voor meer informatie.