Chapter 3 Building Physical Diagrams

Inserting a WHERE clause in a query

To insert a WHERE clause in a query:

1. From the Query property sheet, click the Where tab.
   
   The Where page appears.
2. Click the Add a Row tool.
   
   Click in the first Expression column for the new line in the list.
   
   or
   
   Click in the first Expression column for a new line in the list.
   
   A down arrowhead appears.
3. Click the down arrowhead.
   
   A dropdown listbox appears. It lists all the available columns in the tables defined for the view.
4. Select a column.
   
   Click in the Operator column for the same line.
   
   A dropdown listbox appears listing SQL operators.
5. Select an operator.
   
   Click in the second Expression column for the same line.
   
   A dropdown listbox appears listing available columns.
   
   
      Expression column is not visible
   You can make the second Expression column visible, by clicking the Customize Columns and Filter tool from the tool bar at the top of the page. From the selection box that appears, select the Expression check box and click OK.
   
   
6. Select a column.
7. Type a prefix in the Prefix column.
   
   Type a suffix in the Suffix column.
8. Click OK.

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