ModifyPlan.prototype.joinInner( rightPlan as String, [keys as ondef | ondef[]], [condition as xs.boolean] ) as ModifyPlan
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.
Parameters | |
---|---|
rightPlan | The row set from the right view. |
keys | Equality condition(s) expressed using one or more calls to the function op.on. These conditions are used to compare the left and right rows. |
condition | A boolean expression used to compare the left and right rows. See Boolean Expression Functions for the list of functions used to build boolean expressions. |
keys
and condition
are used to specify
the join condition. keys
allows for a simplified syntax
for equality join condition. While condition
allows for
inequality and complex join conditions.
This method combines keys
and condition
using an AND operator such that:
view .joinInner( otherView, op.on(view.col('column1'), otherView.col('column2')), op.ge(view.col('column3'), otherView.col('column4')) )is the same as
view .joinInner( otherView, null, op.and( op.eq(view.col('column1'), otherView.col('column2')), op.ge(view.col('column3'), otherView.col('column4')) ) )
joinInner
is a method of the following classes:
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()
'use strict'; const op = require('/MarkLogic/optic'); const fruits = op.fromLiterals([ {"fruit" : "mango", "count" : 10}, {"fruit" : "apple", "count" : 7}, {"fruit" : "orange", "count" : 9} ]); const orders = op.fromLiterals([ {"flavor" : "apple", "cups" : 5}, {"flavor" : "orange", "cups" : 14} ]); fruits.joinInner( orders, op.on(op.col('fruit'), op.col('flavor')), op.ge(op.col('count'), op.col('cups')) ) .result() // returns joined rows related to 'apple'.
Stack Overflow: Get the most useful answers to questions from the MarkLogic community, or ask your own question.