Advanced Join Behavior

In some cases, multiple sets of records may use identical join keys, or a single record may include multiple keys (such as a database table with two Id columns). These sections cover how joins are handled for such situations.