![]() |
SQL-J Language Reference
|
Reference Manual |
QueryA query creates a virtual table based on existing tables or constants built into tables. Syntax
{ You can arbitrarily put parentheses around queries, or use the parentheses to control the order of evaluation of UNION operations. UNION operations are evaluated from left to right when no parentheses are present. You can combine two queries into one using the UNION [ALL] operation. UNION builds an intermediate ResultSet with all of the rows from both queries and eliminates the duplicate rows before returning the remaining rows. UNION ALL returns all rows from both queries as the result. UNION (not UNION ALL) is not permitted with Java data types unless they are orderable. For information, see Orderable Java Data Types. Example
-- a Select expression
-- a subquery
-- a UNION |
|
![]() 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. |