Join Operator

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.

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.