TRANSFORM Function Requirements - JOIN

The transform function must take at least one or two parameters: a LEFT record formatted like the leftrecset, and/or a RIGHT record formatted like the rightrecset (which may be of different formats). The format of the resulting record set need not be the same as either of the inputs.