Progress
SQL-89
Guide and Reference


Name Qualifiers

Name qualifiers are necessary to avoid ambiguous references. When you use the same column name in more than one table and those columns are referenced in the same query, you must qualify the column names with their table names (for example, Customer.Cust-Num and Order.Cust-Num in the Sports database).

When accessing multiple or non-Progress databases, you should also qualify table names and view names. If you do not qualify your reference, Progress/SQL takes the name from the default database, if it exists there. In Progress, you receive an error message if the table or view name exists in more than one database.

Table 2–1 shows the general syntax for qualifying column, table, and view names.

Table 2–1: Column, Table, and View Name Qualifiers  
Qualifier
Syntax
Column
[ [ database ] table. ] ] column
Table or view
[ database. ] table or view


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095