Adding Entities to the SELECT and FROM Clauses

1. Select an entity type: Choose Table, Procedure, View, or Synonym. A list of entities for the selected type appears.

2. Add an entity: Drag an entity from the list and drop it in the design area (the blank area on the right).

   • The entity appears as a box in the design area, and its name is added to the SELECT and FROM clauses.

   • Repeat this process to add multiple entities.

3. Alternative methods:

   • Double-click an entity to add it to the design area.

   • To use parameters, drag [PARAMETERS] to the design area. A parameter box will appear in a different color.

Repositioning an Entity’s Attribute List in the Design Area

• Drag the entity's title bar to move it to the desired location in the design area.

Joining Two Entities

1. Drag a field/attribute from one entity and drop it on a field/attribute in another entity.

2. An arrow will connect the two fields, and the SELECT, FROM, and WHERE clauses will update automatically.

Deleting a Join

1. Right-click the arrow representing the join.

2. Select Delete Link.

   • The join is removed, and the corresponding change is reflected in the WHERE clause.

Working with Attributes

Attributes from any entity in the design area can be dragged and dropped into the SELECT, WHERE, GROUP BY, or ORDER BY clauses.

• Include or remove attributes: Select or deselect an attribute to add it to or remove it from the SELECT clause.

WHERE Clause

Adding and Managing Rows

• Insert a row at the top: Click the + icon in the leftmost cell of the column header.

• Insert a row below a specific row: Click the + icon in the desired row.

• Remove a row: Click the - button in the respective condition row.

Specifying Conditions

1. Define a condition by selecting operand1, operand2, and the operator.

2. Join conditions: Form two conditions and select a relation (e.g., AND, OR) in the rightmost column of the first condition.

3. Group conditions: Use opening and closing braces to group conditions.

GROUP BY Clause

The GROUP BY clause specifies grouping criteria for the SQL statement.

• Drag an entity or attribute from the Entity List or design area and drop it in the box under GROUP BY.

HAVING Clause

The procedure for specifying the HAVING clause is the same as the WHERE clause.

ORDER BY Clause

The ORDER BY clause specifies sorting criteria for the SQL statement (ascending or descending).

• Drag an entity or attribute from the Entity List or design area into the ORDER BY section.