MarkLogic Server 11.0 Product Documentation

AccessPlan.prototype.joinInner

AccessPlan.prototype.joinInner(
   rightPlan as String,
   [ondef as String],
   [condition as xs.boolean]
) as ModifyPlan

Summary

This method returns all rows from multiple tables where the join condition is met. In the output row set, each row concatenates one left row and one right row for each match between the keys in the left and right row sets.

The join performs natural joins between columns with the same identifiers. To prevent inadvertent natural joins, specify a different qualifier for the left or right columns or use different column names for the left and right columns.

Usage Notes

joinInner is a method of the following classes:

• AccessPlan
• ModifyPlan

The library functions for building the joinInner parameters are as follows:

• op.on

Example

const op = require('/MarkLogic/optic');

const employees = op.fromView('main', 'employees');
const expenses = op.fromView('main', 'expenses');

const Plan =
  employees.joinInner(expenses, op.on(employees.col('EmployeeID'),
                      expenses.col('EmployeeID')))
           .where(op.gt(expenses.col('Amount'), 150))
           .select([employees.col('EmployeeID'), 'FirstName',
                    'LastName', expenses.col('Amount')]);

  Plan.result()