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.