Can I define a Substitution Rule which uses the contents of a different table to determine which rows are updated in the primary table?
This situation often happens. Take the example of a CUSTOMER table in which you wish to substitute first names based on the contents of the GENDER column held in the CUSTOMER_DETAILS table. The join condition between the tables is the mutual CUSTOMER_ID column. In other words, you want to substitute Female first names in the CUSTOMER table everywhere the equivalent row in the CUSTOMER_DETAILS.GENDER field is ‘F’. This is quite possible to do using only a slightly more complex WHERE Clause. Notice the way the pseudo code of the first part of the WHERE CLAUSE is written (just above the bit you type in). It is written in the form: select
Related Questions
- Why is the access rule table displayed after lookup in the read-only policy query window different from the one configured in Security Manager?
- How can I copy the contents of a single row or column in a table to a different location in the same table?
- What are the substitution ratios for the different sugars compared to regular table sugar?