You can create a WHERE clause in the Table Properties pane for one or more columns. The WHERE clause is used to extract only those records that meet a specified criterion.
-
In the Tables pane, select a table.
-
In the Table Properties pane, click Create WHERE Clause in the Where column for the appropriate table properties.
-
In the Generate Where Clause dialog box, select the appropriate option to create a WHERE clause.
-
Filter by value - Select this option to retrieve records matching a string.
-
Filter by tables - Select this option to retrieve columns matching the criterion.
-
-
Click OK.