oaassignvalues
can be used to apply criteria that is not previously known.
For example, the criteria for a query (query2) may actually
be the results of another query (query1).
Query1 may select the customer numbers from the Orders table,
for all canceled orders.
Query2 then selects the company name, contact, and phone
number from the Customers table for the customer numbers that
were returned from query1.
In this case, the results of query1 are placed in the $VALUES
buffer and used in the WHERE clause of query 2, WHERE customer_no
in $VALUES.
|