The list of Lookup Values contains the distinct values for the Education Level column using the format you defined for EDLEVEL. Select PhD from the list. Because the EQ operator can take only one ...

Click New Query in the context menu. In the Query window, type a statement such as the following: SELECT client_id, first_name, last_name INTO new_table FROM old_table; GO ...

You can use the SQL Query Window to test for missing values in a data set. From the SQL QUERY TABLES window, select SAMPLE.EMPINFO from the list of Available Tables and add it to the list of Selected ...