Kbase 19851: SQL89 - Limits On Joins In SELECT Statement
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/13/2010 |
|
Status: Verified
GOAL:
SQL-89 - Limits On Joins In SELECT Statement
GOAL:
Description of the limitations on explicit joins in a SQL-89 SELECT statement.
SYMPTOM(s):
Error: Table <name> does not exist or cannot be accessed. (962)
FACT(s) (Environment):
All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.x
FIX:
The following types of explicit joins are supported by Progress SQL-89:
Inner Joins
Outer Joins
Left
Right
These restrictions on explicit joins are commonly encountered:
Explicit Joins cannot be specified in a sub query or CREATE VIEW statement.
View references are not allowed, only table references are allowed.
Nesting of explicit joins is not supported.
A right outer join can be specified between no more than two tables in a single SELECT statement. In other words, there can be only one right outer join in a SELECT statement.
There is no limit on number of inner and left outer joins.