Join constructs

Previous Next

USoft supports a variety of join constructs to express SQL SELECT statements that refer to more than 1 table instance.

In all code examples in this help topic, table represents a required table name for which you can optionally supply an alias. Aliases are recommended - all the examples use aliases. Each occurrence of table represents not a table as such, but a table instance: within a single join statement, you can have multiple table occurrences for the same table, resulting in multiple table instances of that table. Table name in USoft may refer to a database table, a Logical View, or a component table.

 

 

collapseInner join: standard syntax
collapseInner join: [INNER] JOIN syntax
collapseOuter join: LEFT/RIGHT [OUTER] JOIN syntax
collapseOuter join: (+) syntax
collapseOuter join: *= syntax
collapseCross join

 

 

See also

Queries and subqueries

DML statements

Table aliases

Transaction control statements

Set operators

Method invocation statements