Join tables

You can use the Join tab to join two or more source tables. You specify join pairs and join conditions based on primary/foreign keys and column names.

1. In the Edit Data Flow view, select the transform in which you want to perform the join.
2. If the tables you want to join are not already available in the Input pane, click New to add additional tables.
3. In the Transform Details, in the Join tab, click the plus icon to add a new join.
4. Select the tables you want to join and the join type.
5. Type a join condition.
6. Click Save.
7. If needed, create additional join conditions.
   Subsequent join pairs take the results of the previous join as the left source.
   Note In an ABAP Query, mixed inner and left outer joins are not supported.