Chapter 3 Building Physical Diagrams

Inserting a HAVING clause in a query

To insert a HAVING clause in a query:

1. From the Query property sheet, click the Having tab.
   
   The Having page appears.
2. Click the Add a Row tool.
3. Click in the first Expression column for a new line in the list.
   
   A down arrowhead appears.
4. Click the down arrowhead.
   
   A dropdown listbox appears. It lists all the available columns in the tables defined for the view.
   
   
      Customizing an expression
   You can customize an expression by clicking the Ellipsis button next to the down arrowhead. An SQL Editor appears. Type an expression in the textbox and click OK. The new expression appears in the Expression column.
   
   
5. Select a column.
   
   Click in the Operator column for the same line.
   
   A dropdown listbox appears listing SQL operators.
6. Select an operator.
   
   Click in the second Expression column for the same line.
   
   A dropdown listbox appears listing available columns.
   
   
      Display the column you need
   If you do not see the column you need, display it with the Customize Columns and Filter tool. See the Defining a filter on a list section in the General Features Guide .
   
   
7. Select a column.
8. Type a prefix in the Prefix column.
   
   Type a suffix in the Suffix column.
9. Click OK.

Copyright (C) 2005. Sybase Inc. All rights reserved.