Zero Copy Connector for ERP table join conditions field descriptions

---
title: Zero Copy Connector for ERP table join conditions field descriptions
description: The Table join condition form in Zero Copy Connector for ERP \(Enterprise Resource Planning\) enables you to create and edit join conditions for tables in an ERP model.
locale: en-US
canonical_url: https://www.servicenow.com/docs/r/integrate-applications/erp-integration-framework/erp-canvas-table-join-condition-descriptions.html
release: brazil
product: ERP Integration Framework
classification: erp-integration-framework
topic_type: reference
last_updated: "2026-08-06"
reading_time_minutes: 1
keywords: [erp, canvas, erp canvas, integration, data hub, zero, copy, connector, sap, table, join, condition]
breadcrumb: [Field descriptions, Reference, Zero Copy Connector for ERP, Workflow Data Fabric]
---

# Zero Copy Connector for ERP table join conditions field descriptions

The Table join condition form in Zero Copy Connector for ERP \(Enterprise Resource Planning\) enables you to create and edit join conditions for tables in an ERP model.

Table joins link different tables through shared fields. Joins enable you to access data from multiple tables based on logical relationships between them. The relationship can be conditional, which you specify using join conditions. Use inner joins or outer joins. An inner join returns records that have matching values in both tables. Outer joins combine left and right join results to return all rows with matches or null values.

Join fields define the common attribute or key used to connect records in a child table with their corresponding parent records.

For process details, see [Add joins between ERP tables](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/brazil/markdown/integrate-applications/erp-integration-framework/erp-canvas-add-join-data-model.md).

<table id="table_alq_dmh_cyb"><thead><tr><th>

Field

</th><th>

Description

</th></tr></thead><tbody><tr><td>

ERP model table field

</td><td>

Name of the join field on the ERP system, which represents an attribute or column in the table where data is stored.

</td></tr><tr><td>

ERP model

</td><td>

ERP model that the join condition applies to.

</td></tr><tr><td>

Field value

</td><td>

Value for the field in the ERP model table that triggers the join.

</td></tr><tr><td>

Order

</td><td>

Numerical value that indicates which part of the join occurs first.This number sets the position of the join condition relative to the other join conditions.

</td></tr><tr><td>

Operator

</td><td>

Operator that defines the conditions for your query. Operators determine how the values are evaluated and filtered in the query results. The following operators are supported:

-   equals
-   contains
-   greater than
-   greater than or equal
-   less than
-   less than or equal
-   not equals

</td></tr><tr><td>

Statement operator

</td><td>

Operator that defines the condition or comparison in your statement. The options are **AND** and **OR**.

</td></tr></tbody>
</table>