HP MPE/iX 6.x Operating System manual Creating Joins Using Calculated Columns

ODBCLink/SE Reference Manual Using ODBCLink/SE With ODBC Applications

Creating Joins Using Calculated Columns

It is possible in Impromptu to create a join using a column that is calculated from two or more fields in one or more tables. To do this, select Catalog, Edit joins; select your primary table and the table you want to join in the upper left part of the screen; click AView as Expression@; and then enter an equation such as:

Table3.Column3 = Table1.column1 + Table2.Column2 ....

The left hand side of this expression is the table you want to join to, and the right hand side is the expression to generate the key. An expression can consist of concatenated fields, SUBSTRING statements, constants, or all of these.

ODBCLink/SE
©M.B. Foster Associates Limited 1995-2000	41