You can use lookup and join tables within the same database in the same unidirectional Copy, Replication, or Synchronization request:
-
Lookup table (see Lookup table)
A lookup table is a built-in data enhancement method called (LookupDatabaseTable) that takes a source column value, looks up this value in a key column (the lookup table), and returns the value of some other single column from the lookup table.
-
Join Table (see Join table)
The join table feature extends table lookup by allowing multiple columns to be retrieved from a secondary join table. When the row is selected from the secondary join table, all the columns in the secondary join table become accessible for use in a secondary target column expression.
No column in the joined table may be referenced in a gate condition where you specify a Boolean expression whose results, if true, allow data transmission of the row based on a valid expression for the column.
Join columns can only be reference in a result expression.