![]() |
SQL-J Language Reference
|
Reference Manual |
TableSubqueryA TableSubquery is a subquery that returns multiple rows. Unlike a ScalarSubquery, a TableSubquery is allowed only:
When used as a TableExpression in a FROM clause, it can return multiple columns. When used with EXISTS, it returns multiple columns only if you use * to return the multiple columns. When used with IN or Quantified comparisons, it must return a single column. Syntax( Query) TableSubquery Examples
-- a subquery used as a TableExpression in a FROM clause
-- a subquery (values expression) used as a TableExpression
-- a subquery used with EXISTS
-- a subquery used with IN
-- a subquery used with a quantified comparison |
|
![]() 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. |