---
title: "Join"
slug: "common-vapidatatype-dataflowetljobnode-transformjoin"
updated: 2026-09-17T09:25:17Z
published: 2026-09-17T09:25:17Z
canonical: "api.ncloud-docs.com/common-vapidatatype-dataflowetljobnode-transformjoin"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://api.ncloud-docs.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Join

This is the conversion (transform) operation information for the join (column merge) type.

              Note

              

For common syntax and field information on the node source, transform, and target types of Data Flow ETL jobs, see [ETLJobNode common](/docs/en/common-vapidatatype-dataflowetljobnode).

### Syntax

The following describes the syntax.

```
private String joinType;
private long leftNodeId;
private long rightNodeId;
private List<JoinCondition> joinConditionList;
private String prefix;
```

### Field

The following describes the fields:

| Field | Type | Required | Description |
| --- | --- | --- | --- |
| `joinType` | String | Required | Join type - `INNER` \| `LEFT_OUTER` \| `RIGHT_OUTER` \| `FULL_OUTER` |
| `leftNodeId` | long | Required | Left node ID |
| `rightNodeId` | long | Required | Right node ID |
| `joinConditionList[].leftField` | String | Required | Left field |
| `joinConditionList[].rightField` | String | Required | Right field |
| `joinConditionList[].joinOperator` | Operator | Required | Operator |
| `joinConditionList[].conditionOperator` | ConditionOperator | Required | Condition |
| `prefix` | String | Optional | Field prefixes to be changed on join |