This section details the syntax
used for sequenced joins (SQL ISO). It is only displayed for technologies with
a join sequencing capacity.
- Clause Location Shows whether the join clause is located on the "FROM" level or the "WHERE" level in the query syntax.
- Brackets Supported in the ON clauses Shows whether the technology accepts sub-sets delimited by parentheses (this is the case with SQL ISO syntax).
- INNER Shows that the technology supports inner joins. The key word specifying an inner join must be given, for example, "INNER JOIN".
- CROSS Shows that the technology supports Cartesian product. The key word specifying a product set must be given, for example, "CROSS JOIN" or ",".
- LEFT OUTER Shows that the technology supports left outer joins. The key word specifying a left outer join must be given, for example, "LEFT OUTER JOIN".
- RIGHT OUTER Shows that the technology supports right outer joins. The key word specifying a right outer join must be given, for example, "RIGHT OUTER JOIN".
- FULL OUTER Shows that the technology supports full outer joins. The key word specifying a full outer join must be given, for example, "FULL OUTER JOIN".
- NATURAL Show that the technology supports natural joins. The key word specifying a natural join must be given, for example, "NATURAL JOIN".
- Not Ordered Join The parameters of non-sequenced joins allow outer join clauses to be generated in the WHERE clause.
No comments:
Post a Comment