---
sourceDocument: Australia Workflow Data Fabric
sourceDocumentLink: https://www.servicenow.com/docs/r/australia/integrate-applications

 Release :

    - australia

ft:locale :

    - en-US

ft:publication_title :

    - Australia Workflow Data Fabric

ft:clusterId :

    - crint

bundleId :

    - crint

workflow :

    - Creator


---

# Join conditions fields

# Zero Copy Connector for ERP table join conditions field descriptions {#ariaid-title1}

Release version: Australia  
Updated August 6, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read  
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://www.servicenow.com/docs/jnklTipUFdSW9c~9efg~wQ "Link multiple ERP (Enterprise Resource Planning) tables to build an ERP model in Zero Copy Connector for ERP using table joins.").  
{#erp-canvas-table-join-condition-descriptions__table_alq_dmh_cyb__entry__2}

| Field | Description |
|-|-|
| ERP model table field | Name of the join field on the ERP system, which represents an attribute or column in the table where data is stored. |
| ERP model | ERP model that the join condition applies to. |
| Field value | Value for the field in the ERP model table that triggers the join. |
| Order | 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. |
| Operator | 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 {#erp-canvas-table-join-condition-descriptions__ul_t4z_hbk_fzb} |
| Statement operator | Operator that defines the condition or comparison in your statement. The options are AND and OR. |
[Table 1. Table join condition form fields]

{#erp-canvas-table-join-condition-descriptions__table_alq_dmh_cyb}