where the following is true:
- tname
- Table that is to receive rows created from input data records
- cname
- Column of the specified table that is to receive the value from a field of matching input records, where the value is identified by the corresponding entry in the fieldname list
- fieldname
- Field of an input record, whose value is given to a column of the specified table that is identified by the corresponding entry in the cname clause in this statement
- expression
- Alternative to the fieldname clause, an expression that includes one or more actual fieldnames as terms may instead be used