Adding One or More Attributes to the Select Clause

Update the select clause to add one or more attributes.

1. Drag the PRODUCTS and SALES tables to the Design window, if they are not there already.
2. To add a single attribute, right-click the attribute you want to add, and select Add Items to Selection. To add more than one attribute, hold down the Ctrl key while you select the attributes you want to add.

   Alternatively, click the PRODUCTS and SALES tabs in the Query Definition pane and select the attributes to add to the select clause. To search for an attribute, click the Search icon and provide your search criteria.

   You can use an asterisk (*) as a wildcard to search for any number of unknown characters. For example:

   • If your attribute is an integer datatype, your search criteria can be one of these:

     int, int*, i*ger

   • If your attribute name contains “PROD” and has “CD” at the end, your search criteria can be:

     *PROD*CD