![]() |
SQL-J Language Reference
|
Reference Manual |
JOIN operationThe JOIN operations, which are among the possible TableExpressions in a FROM clause, perform joins between two tables. (You can also perform a join between two tables using an explicit equality test in a WHERE clause, such as "WHERE t1.col1 = t2.col2".) Syntax
In all cases, you can specify additional restrictions on one or both of the tables being joined in outer join clauses or in the WHERE clause. JOIN Expressions and Query OptimizationFor information on which types of joins are optimized, see Tuning Cloudscape. |
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |