Avaya Business Communications Manager - PeriRDB Manual de usuario descargar pdf (Pagina 26)

PeriRDB User’s Guide

Page 26

You can modify the SQL command manually within the SQL scrolling list. Position

the cursor at the desired character and use the keyboard to modify the command.

PeriSQL accepts valid SQL syntax and keywords.

For example:

If you select Construct SQL after you modify the statement in the SQL scrolling list,

PeriSQL prompts you before it builds the SELECT statement based on your current

selections. Select Continue to overwrite the current statement based on your selections

or Cancel to retain the current (that is, modified) statement.

Selecting Multiple Columns (Join)

If you select columns from more than one table, PeriSQL performs a join operation. A

join associates columns common to two or more tables.

To indicate a join operation in the SELECT statement, PeriSQL:

• lists the selected tables in the FROM clause.

• specifies the relationship between the tables in the WHERE clause.

For example:

The WHERE clause is based on columns that are common to two or more tables in the

query.

PeriSQL automatically builds up to four joins from the currently displayed tables. If

you need to constrain the query further, modify the SQL statement manually within

the SQL scrolling list (see Creating and Customizing the SQL Command in PeriSQL

on page 25).

Enclose character

literals in single quotes

(apostrophes)

1 2 ... 21 22 23 24 25 26 27 28 29 30 31 ... 59 60

Sin comentarios

Avaya Business Communications Manager - PeriRDB Manual de usuario Pagina 26