ODBCLINK/SE Reference Manual (36217-90410)

ODBCLink/SE Reference Manual Using ODBCLink/SE With ODBC Applications
ODBCLink/SE
©M.B. Foster Associates Limited 1995-2000 41
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.