HAVING Details

Database Guide : Database Help : Database windows and dialogs : SQL clause editors : HAVING Details

HAVING Details

Use the HAVING Details window to specify the HAVING clause of a SELECT statement.

You can also use this window to add expressions to the left and right operand lists. This is helpful when the HAVING clause you want to use consists of multiple expressions.

Note:

The HAVING clause will be removed from the SQL statement if you specify an empty expression and then select Apply.

Fields

•Left operand

•Operator

•Right operand

•Expression

Menu-bar choices

•Unary operator

Push buttons

•Select Apply to accept the HAVING clause and close the window.

•Select Add to operand lists to add the expression you have specified to the left and right operand lists.

Tasks

•Specifying a HAVING clause

Opening HAVING Details

You can get to the HAVING Details window from the SELECT Details window by doing the following

1. Make sure you have selected the tables and views you want to include in the FROM clause of the SELECT statement.

2. From the Clause pull-down menu, select HAVING.

Last modified date: 01/29/2015