The Join operator performs a relational join operation on its two input result sets, matching up corresponding rows from the inputs. It does this matching by checking for equality of one or more pairs of columns (where column “A” of the first result set matches column “B” of the second, for example).
In addition to specifying the columns to match, you specify the type of join (inner, outer left, outer right, or outer full) you want WorkSpace Data Federation to perform. You can also specify the algorithm WorkSpace uses, or let it choose the most efficient one for you.
For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com