![]() |
SQL-J Language Reference
|
Reference Manual |
FROM clauseThe FROM clause is a mandatory clause in a SelectExpression. It specifies the real or virtual tables from which the other clauses of the query can access columns for use in expressions. Syntax
FROM [ PROPERTIES joinOrder = { FIXED | UNFIXED } ] The optional PROPERTIES clause before the TableExpressions allows you to "fix" a particular join order--the order of items as they appear in the FROM clause. Otherwise, the optimizer makes its own choice about join order. For more information, see joinOrder in Tuning Cloudscape. FROM clause Examples
SELECT Cities.city_id, Cities.city.showTemperature()
-- other types of TableExpressions
-- force the join order
-- a TableExpression can be a joinOperation. Therefore |
|
![]() 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. |