The query design window consists of two parts. The top half contains the tables selected for the request. Here you can select the columns desired for the result and join tables to each other (see Section The JOIN Predicate). The bottom half contains a more detailed description of the result in the form of a table. Here you can define the position, and, if needed, a synonym, the sort order, and other criteria for the individual columns (see Sections Synonyms for Column Names and The JOIN Predicate).
To select a column for the result, click on the desired column of the particular table in the top half of the query design window and drag the mouse pointer to the desired column of the table for designing the result.
During this drag-and-drop procedure, the mouse pointer changes its form. The selected column cannot be dropped in the database table from which it was selected or in the areas of the screen where the mouse pointer takes the shape of a circle with a diagonal bar. You can drop the column when the mouse pointer appears as a rectangle containing the word Column and is positioned in another database table or the table for designing the result. If another table was selected from the top half of the query design window, a join (see Section The JOIN Predicate) is established between the columns of the two tables, as illustrated by the join line that is then displayed. If the table concerned is the table for designing the result, the particular columns are passed to the result.
You can also select or modify a column of the table for designing the result by selecting the row Field of a column in the table for designing the result. In a combo box, the selected cell contains all columns of all tables you inserted in the top half of the Query design window. From this combo box, you can select the columns to be displayed in the result column.
Unless otherwise specified, the column is displayed in the result table. A column can, however, be available in the result table without being displayed. This can be especially useful, when you want to realize an AND operation with that particular column. To set a selected column to invisible, remove the selection from the row Show: of the table for designing the result.
To delete a column from the table for designing the result, select the name of the column and press the 
key on your keyboard.