The view definition window is divided into two sections. The top half contains the tables selected for the query. Here you can select the columns that are relevant for the view and join the tables to one another (see the Section "join predicate"). The bottom half contains a more detailed description of the view in the form of a table. Here you can determine the sequence, the view column names, if any, the sorting sequence, and other conditions for the individual columns (see Section Naming the View Columns and the paragraph "join predicate").
To select a view column in a table, click on the column in the top half of the query description window and drag the mouse pointer to the desired column of the view description in the lower half of the window by holding down the mouse button.
All columns transferred to the view description are defined as visible view columns. For example, if you wish to use a column only to formulate an AND condition and do not want the column itself to appear as a view column, you can set the column to invisible. To do so, click on the command button under Show for the relevant column; the check mark then disappears and the column is set to invisible. To facilitate the formulation of AND or OR operations, you can transfer one and the same column to the view description a number of times.
LONG Columns in Views
If the view definition is to contain a LONG column, the view definition must be based on a single base table.
Deleting a View Column
To completely remove a column from the view description, click on the column and select the Edit / Delete function.