Use can specify row conditions to limit the rows that are returned in the query results. Without row conditions, all qualifying rows will be returned from the query.
You use the following fields in the bottom section of the diagram window to specify the row conditions:
Use this field to specify simple conditions that apply to the specific column. You can use any of the valid SQL operators. For example, enter "=1" in a row condition for a numeric column. This will specify that only those rows with a value of "1" in this column will be included in the query results.
Use this field to add additional row conditions. You have the choice of adding the conditions using an And or Or operator. You can type any valid SQL expression using connectors and columns.
Check this check box to specify that duplicate rows will be included in the query results.