![]() |
SQL-J Language Reference
|
Reference Manual |
CROSS JOINA CROSS JOIN is one of the JOIN operations. It provides a way to specify a Cartesian product between two tables: it does not allow you to specify the join column. You can, however, specify a WHERE clause. SyntaxTableExpression CROSS JOIN TableExpression Example
SELECT *
SELECT * APPLES |ORANGES |BANANAS |PINEAPPLES
|
|
![]() 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. |