From the C1DataView Definition Statement Builder you can add columns to the view manually or using the Add columns buttons.

To add columns manually (in Diagram View):

1. Select a column to add to the view by selecting the checkbox beside the column item
   

   Note that you may also use the Column drop-down list to select a column to add to the table

2. Enter an alias name for the column in the Alias text box
3. Specify a table using the Table drop-down list

To add columns using the Add columns buttons (in Tree View)

1. From the Columns list in the right pane, select a column to add
2. Click the Add selected columns button . If you want to add all of the columns that are not already in the definition statement, click the Add all columns which are not in statement button. The specified columns appear in the left pane